Try OpenEdge Now
skip to main content
SQL Reference
SQL Reference : OpenEdge SQL Functions : TO_TIMESTAMP
 

TO_TIMESTAMP

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