Date Timezone Oracle PLSQL

  1. Home
  2. Oracle PLSQL
  3. Date Timezone
  4. 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>