TO_TIMESTAMP

Purpose

This function converts the string into a timestamp.

Usage Notes

• The standard format is used if no format is specified, this is defined in session parameter NLS_TIMESTAMP_FORMAT.
• For information, refer to the Date/time format models.
• Session parameter NLS_TIMESTAMP_FORMAT defines the output of the timestamp.

Example

SELECT TO_TIMESTAMP('1999-12-31 23:59:00') TO_TIMESTAMP;

SELECT TO_TIMESTAMP('23:59:00 31-12-1999',
                    'HH24:MI:SS DD-MM-YYYY') TO_TIMESTAMP;