postgresql hour from timestamp code example

Example: postgres timestamp to datetime

to_timestamp(field_name)::timestamp