From: | "Henshall, Stuart - WCP" <SHenshall(at)westcountrypublications(dot)co(dot)uk> |
---|---|
To: | "'samuele(dot)brignoli(at)darpha(dot)com'" <samuele(dot)brignoli(at)darpha(dot)com>, pgadmin-support(at)postgresql(dot)org |
Subject: | Re: timestamp parse error |
Date: | 2002-01-25 12:39:58 |
Message-ID: | E2870D8CE1CCD311BAF50008C71EDE8E01F747A7@MAIL_EXCHANGE |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Ricardo Canani | 2002-01-25 12:40:17 | security wizard enhancements |
Previous Message | Ricardo Canani | 2002-01-25 12:35:20 | [Refresh] button on SQL Output window |