4.9.2.92 TO_TIMESTAMP function (extension)

Syntax

TO_TIMESTAMP ( timestamp_lit )

Description

The scalar function TO_TIMESTAMP converts the given timestamp literal to a timestamp value.

Example

SELECT * FROM DTEST
WHERE C3 = TO_TIMESTAMP('4/18/95 10:41:19')

Notes

• The result is of type TIME.
• Supply the timestamp literal in any valid format. See "Timestamp Literals" for valid formats.