4.9.2.89 TO_DATE function (extension)

Syntax

TO_DATE ( date_lit )

Description

The scalar function TO_DATE converts the given date literal to a date value.

Example

SELECT *
     FROM  orders
     WHERE order_date <= TO_DATE ('12/31/1991') ;

Notes

• The result is of type DATE.
• Supply the date literal in any valid format. See "Date Literals" for valid formats.