framework/resources/Functional/p1tests/date_hour_subract.q

select date_add(to_timestamp('2013/DEC/13 10:13:18', 'YYYY/MMM/dd HH:mm:ss'), interval '-3' HOUR) from voter where voter_id=10;