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

Question

How do I convert the following format to UNIX timestamps?

A value like: 01-02-2015 10:20 PM should be converted to: 1418273999000

I did try to_timestamp function but its not working for me.

Answer 1

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

select extract(epoch from ts) from data