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

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