Exasol 6.2 is no longer supported, and this documentation is no longer maintained or updated.

TO_TIMESTAMP

Purpose

This function converts the string into a timestamp.

Syntax

to_timestamp::=

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

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;