You can use ODBC escape sequences to define a date in a
  database independent way.  For example, to insert a date
  of Jan 21, 1998 into a table, you could use:

    INSERT INTO table_name (date_field) VALUES ({d '1998-01-21'});

  Similar escape sequences are defined for other date/time
  types.  Here's the full set:

    {d 'YYYY-MM-DD'}                  - date
    {t 'HH:MM:SS'}                    - time
    {ts 'YYYY-MM-DD HH:MM:SS'}        - timestamp
    {ts 'YYYY-MM-DD HH:MM:SS.FFFFFF'} - timestamp