Re: timestamp parse error --- *** Migration PLU - Mailing list pgadmin-support

From Dave Page
Subject Re: timestamp parse error --- *** Migration PLU
Date
Msg-id FED2B709E3270E4B903EB0175A49BCB1293325@dogbert.vale-housing.co.uk
Whole thread Raw
List pgadmin-support

> -----Original Message-----
> From: Samuele Brignoli [mailto:samuele.brignoli@darpha.com]
> Sent: 28 March 2002 09:36
> To: Dave Page; pgadmin-support@postgresql.org
> Subject: R: [pgadmin-support] timestamp parse error --- ***
> Migration PLUG-IN ***
>
>
> Dave,
>
> I still have problems with a database generated from sql
> server 2000. I cannot inser data with pgadmin II ( and with
> the migration plugin ) to timestamps fields. This error was
> generated :
> ----------------------------------------
> 28/03/2002 10.26.41 - Error in pgAdmin
> II:frmSQLOutput.cmdSave_Click: -2147467259 - Error while
> executing the query; ERROR:  Bad timestamp external
> representation '2002-10-10 00.00.00'
> --------------------------------------
>
> In this case i've tried to modify a date already inserted
> with Coldfusion ( inserted as odbctimedate ). I can see the
> date inside the pgadmin modify form as 10/10/2002 but I
> cannot modify this . For me it's a bit strange, can you help
> me ? I think that if we solve this poroblem I can also
> migrate correctly windows 2000 datas with the plugin.

Samuele,

Is it possible for you to send me a dump of the table from SQL Server
(obviously I only need a few records for testing). I have a SQL Server 2K I
can play with...

Regards, Dave.

pgadmin-support by date:

Previous
From: "Samuele Brignoli"
Date:
Subject: R: timestamp parse error --- *** Migration PLUG-IN ***
Next
From: Dave Page
Date:
Subject: Re: Source code