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!

Timezone Convert to automatically use with both CST and CDT

MDK999Oct 19 2016 — edited Oct 19 2016

How can I convert within my sql to convert CST to CDT. I do not want to keep updating my code when time changes. Please advice.

Following is the syntax I use within my code

new_time(to_date(sysdate, 'yyyy-mm-dd hh24:mi:ss'), 'GMT', 'CDT')

I dont want to keep changing from 'CDT' to 'CST' when DST changes.. Please advice.

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 16 2016

Added on Oct 19 2016

7 comments

1,368 views