timestamp parse error

From: "Samuele Brignoli" <samuele(dot)brignoli(at)darpha(dot)com>
To: <pgadmin-support(at)postgresql(dot)org>
Subject: timestamp parse error
Date: 2002-01-25 10:50:05
Message-ID: CNEDLAJNHCDEGDBGOHHCCEAHCKAA.samuele.brignoli@darpha.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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

In response to

Browse pgadmin-support by date

  From Date Subject
Next Message Ricardo Canani 2002-01-25 12:35:20 [Refresh] button on SQL Output window
Previous Message Dave Page 2002-01-24 08:14:46 Re: What is Msysconfig?