Re: postgres and unix time format - Mailing list pgsql-general

From Richard Huxton
Subject Re: postgres and unix time format
Date
Msg-id 007001c1052e$486fb740$1001a8c0@archonet.com
Whole thread Raw
In response to postgres and unix time format  (Ryan Mahoney <ryan@paymentalliance.net>)
List pgsql-general
From: "Ryan Mahoney" <ryan@paymentalliance.net>

> Is it possible to select dates from postgres in Unix time format?

Something like:

select extract('epoch' from now());

or

select date_part('epoch',now());

should do it.


pgsql-general by date:

Previous
From: Oliver Vecernik
Date:
Subject: Re: bit operations
Next
From: "Richard Huxton"
Date:
Subject: Re: Remote queries