Skip site navigation (1) Skip section navigation (2)

Re: Bad timestamp external representation

From: Mark Tessier <m_tessier(at)sympatico(dot)ca>
To: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Bad timestamp external representation
Date: 2003-04-29 02:40:09
Message-ID: 20030428224009.5faaf29c.m_tessier@sympatico.ca (view raw or flat)
Thread:
Lists: pgsql-general
On Mon, 28 Apr 2003 15:09:46 -0700 (PDT)
Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> wrote:

Actually, that was the last thing I tried before I wrote this note. Before I entered

herboris=> INSERT INTO cart (cartid, clientid, invdate, paydate) VALUES
herboris-> (4469858, 2, 'current', 'now');

And still got the same error message:

ERROR:  Bad date external representation 'current'



> On Mon, 28 Apr 2003, Mark Tessier wrote:
> 
> > When I try to insert with the "current" constant, as in:
> >
> > herboris=> INSERT INTO cart (cartid, clientid, invdate, paydate) VALUES
> > herboris-> (4469858, 2, 'current_timestamp', 'now');
> >
> > I get the following message:
> >
> > ERROR:  Bad date external representation 'current_timestamp'
> 
> current_timestamp shouldn't be quoted AFAIK.  It's trying to read the
> string current_timestamp as a date value.
> 
> 


-- 
Thanks,

Mark


In response to

Responses

pgsql-general by date

Next:From: Stephan SzaboDate: 2003-04-29 03:26:11
Subject: Re: Bad timestamp external representation
Previous:From: Dennis GearonDate: 2003-04-28 23:58:33
Subject: Re: Bug(?) with cursors using aggregate functions.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group