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.brignoli@darpha.com]
> Sent: 25 January 2002 10:50
> To: pgadmin-support@postgresql.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@postgresql.org so that your
> message can get through to the mailing list cleanly
>