Re: postgres and unix time format

From: "Richard Huxton" <dev(at)archonet(dot)com>
To: <pgsql-general(at)postgresql(dot)org>, "Ryan Mahoney" <ryan(at)paymentalliance(dot)net>
Subject: Re: postgres and unix time format
Date: 2001-07-05 08:41:26
Message-ID: 007001c1052e$486fb740$1001a8c0@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

From: "Ryan Mahoney" <ryan(at)paymentalliance(dot)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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2001-07-05 09:02:14 Re: Remote queries
Previous Message Oliver Vecernik 2001-07-05 08:10:24 Re: bit operations