Skip to Main Content

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!

How to check for DST?

Swethashree_CSM-OracleMay 29 2012 — edited May 29 2012
I am working on current version of APEX. (Total newbie and learning still.)

Is there some way or function to check for DST??
I have to display data from Table1 if DST is applied in AU and data from Table2 if DST is not applied for AU.
How do I check for DST?? This has to be done before data loads on form/report so I need to check this first and then select from respective table for display.
AU applies DST on different days and has no fixed date every year unlike few other places which have a fixed date when they apply DST.

Any help will be appreciated.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 26 2012
Added on May 29 2012
2 comments
511 views