Convert to_timestamp in postgreSQL

Question

Lets do the following:

SELECT to_timestamp(1453336500)::date

Then i get a date 2016-01-21

How does the function work backwards. With the date as input and the number (i guess seconds from 1970) as result?

Laurenz Albe · Accepted Answer · 2020-02-03 11:38:00Z

1

You use extract:

SELECT extract(epoch FROM current_timestamp);

answered Feb 3, 2020 at 11:38

Laurenz Albe

257k22 gold badges312 silver badges388 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1