fredag den 30. august 2013

Unix Timestamps and Postgres

This is a 100% quickie! Convert back and forward between postgres timestamps and the Unix epoch like this:

 psql=> select extract(epoch from to_timestamp(1354012641));
 date_part
------------
 1354012641
(1 row)

Ingen kommentarer:

Send en kommentar