framework/resources/Functional/p1tests/to_date3.q

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