framework/resources/Functional/p1tests/timestamp_daytosec_minus.q

select date_add(to_timestamp('2013/DEC/13 10:13:18', 'YYYY/MMM/dd HH:mm:ss'), interval '-1 10:20:30' DAY to second) from voter where voter_id=10;