Here's how you get unixtime from a Postgres date field.

SELECT extract('epoch' from DateField) AS UnixTime FROM Table;