Re: Bad timestamp external representation

On Mon, 28 Apr 2003, Mark Tessier wrote:

> 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'

You didn't give a version, but my 7.3 box gives
ERROR: 'CURRENT' is no longer supported
for simple inserts to date columns with a quoted current.

I'd think the correct sequence of values would be:
(4469858, 2, current_timestamp, 'now')
since current_timestamp isn't like a string literal, but is a special date
value function.