Date and time are parsed using the standard SQL literal strings:
DATE 'YYYY-MM-DD'
TIME 'HH:MM:SS[.sss]'
TIMESTAMP 'YYYY-MM-DD HH:MM:SS[.sss]'
For example:
DATE '1971-12-24'
TIMESTAMP '2003-10-23 11:00:02'