framework/resources/Functional/hive/hive_functions/date_part.q

select date_part('year',create_date), date_part('month',create_date),date_part('day', create_date) from voter_parquet where voter_id=10;