Converts the given timestamp literal to a timestamp value.

Syntax

TO_TIMESTAMP ( timestamp_lit )

Notes

  • The result is of type TIME.
  • Supply the timestamp literal in any valid format.

Example

The following example shows how to use the TO_TIMESTAMP function:

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

Compatibility

Progress Extension