How to convert date time into unix epoch value in Postgres?

If your data is stored in a column called ts, in a table called data, do this:

select extract(epoch from ts) from data