How do I get the current time in seconds in the unix epoch? - Mailing list pgsql-hackers

From Bill Studenmund
Subject How do I get the current time in seconds in the unix epoch?
Date
Msg-id Pine.NEB.4.33.0110110910290.15927-100000@vespasia.home-net.internetconnect.net
Whole thread Raw
Responses Re: How do I get the current time in seconds in the unix epoch?
Re: How do I get the current time in seconds in the unix epoch?
List pgsql-hackers
I have a function in PL/pgSQL which needs the current time in seconds
expressed as an int4. In 7.1 I was able to get this (I thought) with
date_part(''epoch'', timestamp ''now'') . That doesn't seem to work for me
in last week's -current.

Here's the PLpgSQL:
       v_seed := date_part(''epoch'', timestamp ''now'');

And here's the output:

NOTICE:  Error occurred while executing PL/pgSQL function
NOTICE:  line 4 at assignment
ERROR:  Timestamp with time zone units 'epoch' not recognized

What's the best way to do this?

Take care,

Bill



pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: HISTORY
Next
From: Bruce Momjian
Date:
Subject: Re: BUG: text(varchar) truncates at 31 bytes