Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Date Timestamp Functions

 

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>