Hi Trafodioneers, Does Trafodion have a function which can convert numeric to timestamp?
The value 1500220712 stands for 2017-07-16 23:58:32 in Linux. [root@bigdata157 ~]# date -d @1500220712 +"%Y-%m-%d %H:%M:%S" 2017-07-16 23:58:32 Can we convert it the timestamp in Trafodion? I saw function CONVERTTIMESTAMP <http://trafodion.incubator.apache.org/docs/sql_reference/index.html#converttimestamp_function> in SQL manual, but it seems it does not work. SQL>select converttimestamp(1500220712) from dual; *** ERROR[8405] The operand of function CONVERTTIMESTAMP is out of range. [2017-11-30 13:36:11] Best regards, Yuan
