Date Timestamp Functions Oracle PLSQL Tutorial

  1. Home
  2. Oracle PLSQL Tutorial
  3. Date Timestamp Functions
  4. Combining TO_CHAR to Format SYSDATE
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>