smalig
asked on
oracle sql
Hello experts,
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."LASTUPDA TETIME",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.
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."LASTUPDA
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
What do these queries return in your system?
select sysdate from dual;
select systimestamp from dual;