Hi all,
I have the following in a plpgsql proc on 7.3.4:
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 );
-- p
Stephan,
Thanks, this does work. I assume that the usage of 'TIMESTAMP'
only applies when a literal representation of the date is
given.
Matthew
Stephan Szabo wrote:
On Wed, 15 Jun 2005, Matthew Phillips wrote:
Hi all,
I have the following in a plpgsql proc on 7.3.4:
DECLARE
.
