Re: How do I get the current time in seconds in the unix - Mailing list pgsql-hackers

From Bill Studenmund
Subject Re: How do I get the current time in seconds in the unix
Date
Msg-id Pine.NEB.4.33.0110150628220.22955-100000@vespasia.home-net.internetconnect.net
Whole thread Raw
In response to Re: How do I get the current time in seconds in the unix epoch?  ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>)
List pgsql-hackers
On Mon, 15 Oct 2001, Christopher Kings-Lynne wrote:

> Hmmm.  I don't know why date_part isn't working, but I now only use the
> EXTRACT syntax for maximum SQL compatibility.  ie. Do this instead:
>
> v_seed := EXTRACT (EPOCH FROM CURRENT_TIMESTAMP);

Unfortunatly that gives the same error. I think the problem is that the
underlying code isn't liking the EPOCH timezone. Tom mentioned he had
patches.

Take care,

Bill



pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: ecpg - GRANT bug
Next
From: Bill Studenmund
Date:
Subject: Re: ecpg - GRANT bug