Hi, Please write a JIRA asking for this feature. It would be simple to enhance Trafodion's TO_TIMESTAMP function to support this.
In the meantime, casting to TIMESTAMP should do the trick. That is the ANSI-standard syntax for this feature. Dave From: Liu, Yuan (Yuan) [mailto:[email protected]] Sent: Monday, March 5, 2018 1:30 AM To: [email protected]; [email protected] Subject: Can Trafodion support transfer string to timestamp with millseconds? 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
