framework/resources/Functional/p1tests/extract_timestamp.q

select extract(day from (to_timestamp('2014-02-12 03:18:31:07 AM', 'YYYY-MM-dd HH:mm:ss:SS a'))) from voter where voter_id=10;