SQL Reference Guide

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 of DATE literals.