Trafodion support of TO_DATE

2016-03-19 Thread Liu, Ming (Ming)
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)

RE: Trafodion support of TO_DATE

2016-03-19 Thread Anoop Sharma
] Sent: Wednesday, March 16, 2016 8:51 PM To: user@trafodion.incubator.apache.org 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

答复: Trafodion support of TO_DATE

2016-03-19 Thread Liu, Ming (Ming)
收件人: user@trafodion.incubator.apache.org 主题: RE: Trafodion support of TO_DATE 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