Re: postgres and unix time format

Поиск
Список
Период
Сортировка
Искать

Re: postgres and unix time format

От:
"Richard Huxton" <dev@archonet.com>
Дата:
From: "Ryan Mahoney" 

> 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.

postgres and unix time format

От:
Ryan Mahoney <ryan@paymentalliance.net>
Дата:
Is it possible to select dates from postgres in Unix time format?

Thanks!

-Ryan Mahoney
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.251 / Virus Database: 124 - Release Date: 4/26/01
FAQ