TO_TIMESTAMP()

Description of to_timestamp.eps follows

 

Syntax:

Example:
SELECT TO_TIMESTAMP ('10-Sep-02 14:10:10.123000', 'DD-Mon-RR HH24:MI:SS.FF')
FROM DUAL;

Example, 2

SELECT TO_TIMESTAMP ('10-Sept-02 14:10:10.123000'
DEFAULT NULL ON CONVERSION ERROR,
'DD-Mon-RR HH24:MI:SS.FF',
'NLS_DATE_LANGUAGE = American') "Value"
FROM DUAL;

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top