Skip to Main Content
Forums

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!

Convert UTC to Localtime

user10177353Aug 17 2012 — edited Aug 17 2012
Hi All,
I'm using Oracle 9.2.

I have a date as 20120816053010 in UTC format. I have to convert it localtime. However when I do to_date ('20120816053010', 'YYYYMMDDHH24MISS') and insert into Date column in the table, it drops off the time and stores the date.

An idea of a generic procedure that converts a datetime from UTC to localtime, preferrably an Australia (ACT, VIC, NSW) should be fine. Kindly help.

Thanks in advance
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 14 2012
Added on Aug 17 2012
2 comments
2,049 views