Can Trafodion support transfer string to timestamp with millseconds?

[Liu, Yuan (Yuan)]

Hi Trafodioneers,

I know we can transfer a string to timestamp using to_date, to_timestamp or 
cast(.. as timestamp)

Now I have a string 20160912100706259067 and want to transfer to timestamp with 
millseconds. The only way I can think is firstly changing the value to 
2016-09-12 10:07:06.259067 and then using to_timestamp('2016-09-12 
10:07:06.259067'). Is there any better way?

In Oracle, it supports TO_TIMESTAMP('20160912100706259067', 
'YYYYMMDDHH24MISSFF6'), it seems we can not support it.

Best regards,
Yuan