Re: How do I get the current time in seconds in the unix

From: Bill Studenmund <wrstuden(at)netbsd(dot)org>
To: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
Cc: <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: How do I get the current time in seconds in the unix
Date: 2001-10-15 13:29:15
Message-ID: Pine.NEB.4.33.0110150628220.22955-100000@vespasia.home-net.internetconnect.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Balaji Venkatesan 2001-10-15 14:06:03 Interchange
Previous Message Marc G. Fournier 2001-10-15 12:41:50 Snaptshot appears fine to me ...