Finding the First Monday After the Current Date and Time : SYSDATE « Date Timezone « Oracle PL / SQL






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

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> --








Related examples in the same category

1.select sysdate
2.Using the SYSDATE function: return the current date from the system
3.Get current operating system date
4.Combining TO_CHAR to Format SYSDATE
5.Removing the Time from SYSDATE
6.Truncating to the Quarter
7.Adding Two Months to SYSDATE
8.Adding One Month a certain date
9.use sysdate to init a variable
10.Minus days from sysdate