[jira] [Created] (TRAFODION-2979) to_date can not support transfering string to timestamp with millseconds

["Yuan Liu (JIRA)" <ji...@apache.org>]

Yuan Liu created TRAFODION-2979:
-----------------------------------

             Summary:  to_date can not support transfering string to timestamp with millseconds
                 Key: TRAFODION-2979
                 URL: https://issues.apache.org/jira/browse/TRAFODION-2979
             Project: Apache Trafodion
          Issue Type: Improvement
          Components: sql-general
    Affects Versions: 2.1-incubating
            Reporter: Yuan Liu


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.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)