TIMEDATE calculation

From: Aaron Spiteri <aaron(at)m1group(dot)com(dot)au>
To: pgsql-admin(at)postgresql(dot)org
Subject: TIMEDATE calculation
Date: 2002-07-17 02:19:38
Message-ID: 20020717.2193800@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 Luca Zancan 2002-07-17 06:29:52 Re: Problem compiling PostgreSQL 7.2.1 on RedHat 7.2
Previous Message Aaron Spiteri 2002-07-17 02:10:56 SQL date calculation problem