Postgres SQL: Day to day tips

Dates

transform an int as readable timestamp:

select to_timestamp(FIELD_TO_CONVERT) from table;