Re: timestamp parse error

It doesn't know this is a timestamp so I guess it sees 00 and tries to read
as a number. to get it to work try putting it in appostraphes. This should
make it of type text. If this isn;t automatically cast then us the following
(assuming its a timestamp):
CAST ('2001-12-04 00:00:00.0' AS timestamp)
- Stuart

> -----Original Message-----
> From: Samuele Brignoli [mailto:samuele(dot)brignoli(at)darpha(dot)com]
> Sent: 25 January 2002 10:50
> To: pgadmin-support(at)postgresql(dot)org
> Subject: [pgadmin-support] timestamp parse error
>
>
> I'm trying to execute this :
>
> insert into
> ahepatch(cpccchk,ptcodrel,ptdatins,ptdescri,ptnumpat,ptreleas)
> values ('kfdujcqkgp','1.02-A0001',2001-12-04 00:00:00.0,'Aggiornamento
> EURO-KIT',1,'1.2');
>
> I obtain an error :"Parse error near or at "00".
>
> What is the problem ? The form 00:00:00.0 is contemplated ...
> or not ?!
>
> --kako
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>