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!

Converting Date to timestamp with time zone

RinneNov 3 2009 — edited Nov 4 2009

Hi, I have a date column in UTC time zone. I need to convert it to Pacific time, but I'd like to convert it to the right time before or after the dalylight savings. Is there an automatic way to calculate this based on the date in the column?

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 2 2009

Added on Nov 3 2009

2 comments

16,673 views