{d 'yyyy-mm-dd'} -- e.g. WHERE arrivalDate < {d '2002-12-31'} {t 'hh:mm:ss'} -- e.g. WHERE arrivalTime < {t '23:59:59'} {ts 'yyyy-mm-dd hh:mm:ss'} -- e.g. WHERE arrivalTimestamp < {ts '2002-12-31 23:59:59'}