Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Date Timestamp Functions

 

Removing the Time from SYSDATE

SQL>  SELECT TO_CHAR(TRUNC(SYSDATE),'MM/DD/YYYY HH:MM:SS AM')   2      "Today's Date and Time"   3       from DUAL; Today's Date and Time ---------------------- 06/02/2007 12:06:00 AM SQL>