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'}
{d 'yyyy-mm-dd'}
DATE constants can be represented and used in comparisons with OEM Dates under Date Type.
Select cust_num from customer where ship_date>{d'1996-09-30'}