Thread: ABSTIME = UNINX TIMESTAMP???

ABSTIME = UNINX TIMESTAMP???

From
Olcsák József
Date:

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 ?