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 first published in May 2001

Dig deeper on Oracle database design and architecture

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close