Time

From: Rob Kirkbride <rob(dot)kirkbride(at)thales-is(dot)com>
To: PostgreSQL general <pgsql-general(at)postgresql(dot)org>
Subject: Time
Date: 2005-04-04 12:49:52
Message-ID: 425137F0.5060902@thales-is.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

  • Re: Time at 2005-04-04 13:32:16 from Ragnar Hafstað

Browse pgsql-general by date

  From Date Subject
Next Message Ragnar Hafstað 2005-04-04 13:32:16 Re: Time
Previous Message Magnus Hagander 2005-04-04 11:48:10 Re: stored procedures / C-Language