The proper method to find the first Monday in a given month : NEXT_DAY « Date Timezone « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Date Timezone
  3. NEXT_DAY

The proper method to find the first Monday in a given month


SQL>
SQL>
SQL>
SQL> -- The proper method to find the first Monday in a given month.
SQL> SELECT TO_CHAR(NEXT_DAY('31-AUG-97','Monday'),'MM/DD/YYYY HH:MM:SS AM') "Next_Day" from DUAL;

Next_Day
----------------------
09/01/1997 12:09:00 AM

SQL>








Related examples in the same category

1.NEXT_DAY: the date of the day of the week following a particular date
2.Finding the first Monday in the month of September
3.NEXT_DAY('01-AUG-97','Monday'): Finding the first Monday in the month of August
4.NEXT_DAY(SYSDATE,'Monday'): Finding the first Monday after the current date and time
5.select next_day( date'2001-09-11', 'SUNDAY' )
6.select next_day( date'2002-01-01', 'FRI' )