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 GMT to Local time

884364Aug 20 2012 — edited Aug 20 2012

Hi All,

I am having confusion in converting UTC to locatime. I have column that stores time in UTC but I want to get the local time when I will do query on it.

I am looking for something like when I do query "SELECT some_func(time_column) FROM myTable" will return me corresponding local time for each row. I don't know whether there is any built in function for this.

Is there any such function or any logic to get the desire result?

Any help is appreciated.

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 17 2012

Added on Aug 20 2012

#date, #time

9 comments

4,565 views