Postgres + Unixtime

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

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


Note: Replies will be formatted with PHP Markdown Extra syntax.

Name: Email (Not Required):
 
Logged IP: 34.204.183.113
To prevent spam please submit by clicking the kitten: