framework/resources/Functional/p1tests/date_daytosec_minus.q

select date_add(to_date('05 Dec 2013', 'dd MMM YYYY'), interval '-1 10:20:30' DAY to second) from voter where voter_id=10;