ABSTIME = UNINX TIMESTAMP??? - Mailing list pgsql-general

From Olcsák József
Subject ABSTIME = UNINX TIMESTAMP???
Date
Msg-id 000e01c18622$ad5f5280$3c14a8c0@ritek.hu
Whole thread Raw
List 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 ?

 

pgsql-general by date:

Previous
From: "Rob Hoffman"
Date:
Subject: Re: simple query question
Next
From: "Mike Smialek"
Date:
Subject: Re: case sensititvity bug in foreign keys on cygwin