Re: Bad timestamp external representation

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: Mark Tessier <m_tessier(at)sympatico(dot)ca>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Bad timestamp external representation
Date: 2003-04-28 22:09:46
Message-ID: 20030428150719.O14646-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message ed despard 2003-04-28 22:17:32 adding times togeather
Previous Message scott.marlowe 2003-04-28 21:59:50 Re: > 16TB worth of data question