Time - Mailing list pgsql-general

From Rob Kirkbride
Subject Time
Date
Msg-id 425137F0.5060902@thales-is.com
Whole thread Raw
Responses Re: Time  (Ragnar Hafstað <gnari@simnet.is>)
List pgsql-general
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?

Thanks for any help,

Rob

pgsql-general by date:

Previous
From: "Magnus Hagander"
Date:
Subject: Re: stored procedures / C-Language
Next
From: Ragnar Hafstað
Date:
Subject: Re: Time