You will have to convert the TO_DATE part of the query to an explicit
datetime literal that looks like:
timestamp '2016-03-17 11:47:06'
With TO_DATE support (this is on trafodion now but will be externally
available as part of Traf 2.0), you
can use the statement that you have listed.
But.the format part need to match the string datetime value. In your
example, it doesn't.
The correct syntax will be:
to_date('20160317114706', 'YYYYMMDDHH24MISS')
or
to_date('2016-03-17 11:47:06', 'YYYY-MM-DD HH24:MI:SS')
anoop
From: Liu, Ming (Ming) [mailto:[email protected]]
Sent: Wednesday, March 16, 2016 8:51 PM
To: [email protected]
Subject: Trafodion support of TO_DATE
Hi, all,
I know there will be a new feature to support TO_DATE, currently, without
this feature, is there any way to migrate a query using TO_DATE?
Example:
insert into myTbl (staff_id,
orbat_code,operate_time,ip_arr,browser_version,orbat_desc)
values('ADMIN','V1369930001010',to_date('20160317114706','yyyy-MM-dd
hh24:mi:ss')
thanks,
Ming
