convert timestamp to date in postgress code example Example: postgres timestamp to datetime to_timestamp(field_name)::timestamp