Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Date Timestamp Functions

 

Truncates 7

SQL>  SELECT TO_CHAR(TRUNC(TO_DATE('25-MAY-2005 19:45:26',   2    'DD-MON-YYYY HH24:MI:SS'), 'HH24'), 'DD-MON-YYYY HH24:MI:SS')   3  FROM dual; TO_CHAR(TRUNC(TO_DAT -------------------- 25-MAY-2005 19:00:00 SQL>