ABSTIME = UNINX TIMESTAMP???

From: Olcsák József <joe78(at)freemail(dot)hu>
To: <pgsql-general(at)postgresql(dot)org>
Subject: ABSTIME = UNINX TIMESTAMP???
Date: 2001-12-16 11:13:22
Message-ID: 000e01c18622$ad5f5280$3c14a8c0@ritek.hu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi!

I have a question:

I use a query,

select extract(epoch from current_timestamp);

date_part

------------

1008500586

This returns the UNIX timestamp ...

and I use an another query:

select current_timestamp::abstime::int4;

?column?

------------

1008500672

PostgreSQL abstime type equal UNIX timestamp ?

Browse pgsql-general by date

  From Date Subject
Next Message Peter Pilsl 2001-12-16 11:22:28 Re: subtable <-> bigtable
Previous Message Emmanuel Asante 2001-12-16 08:53:15 PostgreSQL 7.1.3 Installation Problem