PostgreSQL and time zones

If you do not feel anything special when someone says “timezones” then you can consider yourself to be lucky. If your application runs only in your local time zone a you never ever need to convert date/time between timezones then you are really lucky. But...

PostgreSQL Timestamp vs. UNIX timestamp

select extract(epoch from clock_timestamp()) as present_time_unix, to_timestamp( extract(epoch from clock_timestamp())) as present_time_unix_back_to_postgresql