SQL date calculation problem

From: Aaron Spiteri <aaron(at)mep(dot)com(dot)au>
To: pgsql-admin(at)postgresql(dot)org
Subject: SQL date calculation problem
Date: 2002-07-17 02:10:56
Message-ID: 20020717.2105600@scooby.m1group.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi all,
I using postgresql 7.1.3 on RH 7.2 server. I am having trouble with
TIMEDATE calculation using the pgplsql procedural language the logic is
has follows:
FOR r IN SELECT time_span FROM t WHERE name = ''NEW'' LOOP
NEW.end_date := r.time_span + now();
END LOOP;
When I try running this routine I get an error "Bad timestamp external
representation '11:39:09' ". This routine ran in previous versions of
postgresql does any one have any ideas.

Browse pgsql-admin by date

  From Date Subject
Next Message Aaron Spiteri 2002-07-17 02:19:38 TIMEDATE calculation
Previous Message Peter Eisentraut 2002-07-16 21:58:20 Re: Problem compiling PostgreSQL 7.2.1 on RedHat 7.2