I need to insert a value that is from a to_date function to a timestamp column
ex: i have this select statement -- select TO_DATE(substr(M."LASTUPDATETIME",1,19),'YYYY-MM-DD HH24:MI:SS') from a
I need to insert this value to a timestamp(0) column.
the output from the select is -- 2015-06-30 05:21:55
and when I insert it to the timestamp column it becomes -- 0030-06-15 00:00:00
how can I fix this?
thanks for your help.