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".
Format | Sample | 7.03 and above | 6.20 |
---|---|---|---|
{d 'date'} | {d '2010-12-31'} | Yes | Yes |
{d date} | {d 2010-12-31} | Yes | Yes |
'date' | '2010-12-31' | Yes | Yes |
#date# | #2010-12-31# | Yes | Yes |
Date 'date' | Date '2010-12-31' | Yes | No |
TO_DATE('date') | TO_DATE('2010-12-31') | No | No |