framework/resources/Functional/p1tests/date_part_hour.q

select date_part('hour',cast(create_time as timestamp)) from voter where voter_id=10;