How to convert date time into unix epoch value in

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

Answer 2

To add Joe's answer, you can use date_part, i think it's syntax is clearer than 'extract'.

select date_part('epoch', ts) from data;