Supported Date Literals

This table shows the supported format for date, which is treated as a literal in KCML 7 and 6. The date is in format of "YYYY-MM-DD".

FormatSample7.03 and above6.20
{d 'date'}{d '2010-12-31'}YesYes
{d date}{d 2010-12-31}YesYes
'date''2010-12-31'YesYes
#date##2010-12-31#YesYes
Date 'date'Date '2010-12-31'YesNo
TO_DATE('date')TO_DATE('2010-12-31')NoNo