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!

8i MST MDT

52341Sep 9 2003 — edited Sep 9 2003

What is the best way to deal with daylight savings? I am doing the following in a view:
to_char(new_time(conditions.timestamp,'GMT','MST'),'MM/DD/YYYY HH:MI AM') AS COVDATE
Is there a way to have the database tell the code when to use 'MST' or 'MDT' in an 8i database?
How is it done in a 9i database?

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 7 2003

Added on Sep 9 2003

#general-database-discussions

1 comment

190 views