Problem solve Get help with specific problems with your technologies, process and projects.

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


Dig Deeper on Oracle database design and architecture

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close