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

TO_TIME

Converts the given time literal to a time value.

Syntax

TO_TIME ( time_literal )

Notes

*The result is of type TIME.
*Supply the time literal in any valid format.

Example

The following example shows how to use the TO_DATE and the TO_TIME functions:
SELECT * FROM orders
WHERE order_date < TO_DATE ('05/15/2003')
AND order_time < TO_TIME ('12:00:00') ;

Compatibility

Progress extension