Date Timezone Oracle PLSQL

  1. Home
  2. Oracle PLSQL
  3. Date Timezone
  4. Finding the First Monday After the Current Date and Time
SQL> --
SQL>
SQL> SELECT TO_CHAR(NEXT_DAY(SYSDATE,'Monday'),'MM/DD/YYYY HH:MM:SS AM')
  2       "Next_Day"
  3   from DUAL;
Next_Day
----------------------
06/23/2008 06:06:08 PM
1 row selected.
SQL>
SQL> --