SQL — Date Constants

Syntax

{d 'yyyy-mm-dd'}

Description

DATE constants can be represented and used in comparisons with OEM Dates under Date Type.

Example

Select cust_num from customer where ship_date>{d'1996-09-30'}