Time

On Mon, 2005-04-04 at 13:49 +0100, Rob Kirkbride wrote:

Hi,

I'm trying to fetch out the epoch value of a time, the data type is
'timestamp with time zone'. When I do select extract(epoch from time) it
returns a fractional part as well.
Am I doing this the correct way? Is the fractional part microseconds?

no, it is fractions of a second.

test=# select extract(epoch from '2005-04-04 14:00:00.000000
+00'::timestamptz);
date_part
------------
1112623200
(1 row)

test=# select extract(epoch from '2005-04-04 14:00:00.123400
+00'::timestamptz);
date_part
-----------------
1112623200.1234
(1 row)

the accuracy probably depends on your platform

gnari