Oracle Database Discussions

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!

Capture data in UTC date format.

1607025Jul 21 2014 — edited Jul 22 2014

Hi All,

I have a requirement to capture data in UTC date format (e.g. "2014-05-30T15:00:00+10:00") in the database. I have accordingly set up the column data type as TIMESTAMP(6) WITH TIME ZONE . Please let me know if this suffices or do I have to use to_date convert function explicitly to get the date in the desired format.

Thanks in advance.

Regards,

Sandeep.

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 19 2014

Added on Jul 21 2014

#general-database-discussions

7 comments

2,766 views