From: | Matthew Phillips <mphillips(at)timing(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | plpgsql - TIMESTAMP variables in EXTRACT |
Date: | 2005-06-15 18:30:36 |
Message-ID: | 42B073CC.8050007@timing.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi all,
I have the following in a plpgsql proc on 7.3.4:
<code>
DECLARE
...
curTime TIMESTAMP;
ppsCnt INT;
BEGIN
...
-- this works
SELECT INTO curTime localtimestamp;
-- get unix seconds from current time (doesn't work)
SELECT INTO ppsCnt EXTRACT (EPOCH FROM TIMESTAMP curTime );
-- parser complains here ^
-- get unix seconds from random string (works)
SELECT INTO ppsCnt EXTRACT (EPOCH FROM TIMESTAMP
\'1990-05-04 01:02:03\' );
-- do stuff with ppsCnt and curTime
...
</code>
Here are the error messages:
WARNING: Error occurred while executing PL/pgSQL function XXX
WARNING: line XXX at select into variables
ERROR: parser: parse error at or near "$1" at character XX
All I would like to do is get the current time and convert
it to an integer value. Am I attempting to do the impossible or
is this another simpler way to shove unix seconds of the current
time in a variable? Please also inform me as to why my current
syntax is invalid.
Thanks,
Matthew
From | Date | Subject | |
---|---|---|---|
Next Message | Devrim GUNDUZ | 2005-06-15 19:00:49 | Re: graphic client |
Previous Message | Jeff Eckermann | 2005-06-15 17:06:35 | Re: users/users groups management from MS Access front-end |