Resolving DST Start and DST End

Here are a few rules for determining DST Start and DST End dates.

What if you have a PL/SQL procedure that bases processes on dates and hours, and you need to determine if a date...

is DST Start or DST End? Use the following built-in functions to capture DST Start and End for your application and apply as you see fit. Just remember the rules: 1) DST_Start is ALWAYS the first SUNDAY of April and 2) DST_End is ALWAYS the last SUNDAY of October.

SELECT NEXT_DAY(TO_DATE(TO_CHAR(V_DATE,'YYYY')||'-03-31','YYYY-MM-DD'),'SUNDAY') INTO dst_start FROM dual;

SELECT NEXT_DAY(TO_DATE(TO_CHAR(V_DATE,'YYYY')||'-10-31','YYYY-MM-DD')-7,'SUNDAY') INTO dst_end FROM dual;

For More Information


This was last published in May 2001

Dig Deeper on Oracle database design and architecture

PRO+

Content

Find more PRO+ content and other member only offers, here.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close