Release 10.1A: OpenEdge Data Management:
SQL Reference

> ## TO_TIMESTAMP

> Converts the given timestamp literal to a timestamp value.

> #### Syntax

>     TO_TIMESTAMP ( timestamp_lit )

> 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')

> #### Notes

> - The result is of type `TIME`.

> - Supply the timestamp literal in any valid format.

> ##### Compatibility

> Progress Extension

Copyright © 2005 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095