Re: timestamp parse error --- *** Migration PLU

> -----Original Message-----
> From: Samuele Brignoli [mailto:samuele(dot)brignoli(at)darpha(dot)com]
> Sent: 28 March 2002 09:36
> To: Dave Page; pgadmin-support(at)postgresql(dot)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.