SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

insert UTC time into timestamp column

user567271Nov 24 2016 — edited Nov 28 2016

I have data in text file in this format

2016-11-13 13:53:16 UTC

and I want to store this data in a timestamp column. So I have a timestamp column in table mytab and ran

insert into mytab values (to_timestamp('2016-11-13 13:53:16 UTC','YYYY-MM-DD HH24:MI:SS TZR'));

and got

"ORA-01821: date format not recognized"

Just wonder what datetime format I could use her to insert the data. Thanks.

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 26 2016

Added on Nov 24 2016

6 comments

8,326 views