Purpose
This function converts the string into a timestamp.
Syntax
to_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
Copy
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;