Combining TO_CHAR to Format SYSDATE : SYSDATE « Date Timestamp Functions « Oracle PL/SQL Tutorial






SQL> SELECT TO_CHAR(SYSDATE,'MM/DD/YYYY HH:MM:SS AM')
  2        "Today's Date and Time" from DUAL;

Today's Date and Time
----------------------
06/02/2007 08:06:14 PM

SQL>
SQL>








13.17.SYSDATE
13.17.1.SYSDATE() returns the current datetime set in the operating system
13.17.2.last_day(sysdate)
13.17.3.Default Output of SYSDATE
13.17.4.Combining TO_CHAR to Format SYSDATE
13.17.5.Removing the Time from SYSDATE
13.17.6.Truncating to the Quarter
13.17.7.Adding Two Months to SYSDATE
13.17.8.Adding One Month
13.17.9.Finding the First Monday After the Current Date and Time