migration wizard question with timestamps

I have still this problem migratin an sql server 2000 db to a postgresql
one.
The migration wizard throws me this error :

---------
An error occured at: 26/02/2002 9.50.15:
-2147467259: Error while executing the query;
ERROR:  Bad timestamp external representation '2001-12-04 00.00.00'
------------

when trying to execute the following code :

------------
INSERT INTO "ahepatch" ("ptcodrel", "ptreleas", "ptnumpat", "ptdatins",
"ptdescri", "cpccchk") VALUES ('1.02-A0001     ', '1.2       ', '1',
'2001-12-04 00.00.00', 'Aggiornamento EURO-KIT                            ',
'kfdujcqkgp')
------------

I don't know how to make it works, can someone help me? Is it a bug in the
wizard or a bad representation in my source db, or what ?

    Samuele.


-----Messaggio originale-----
Da: pgadmin-support-owner@postgresql.org
[mailto:pgadmin-support-owner@postgresql.org]Per conto di Samuele
Brignoli
Inviato: venerdì 15 febbraio 2002 9.51
A: pgadmin-support@postgresql.org
Oggetto: [pgadmin-support] pgadmin sql server migration timestamps


Hello,

I'm trying to migrate a sql server db to a postgresql db using pgadmin 1.2.0
migration plugin. When doing that I obtain this error :

Creating table: AHEPATCH
  Copying data...

An error occured at: 15/02/2002 9.46.58:
-2147467259: Error while executing the query;
ERROR:  Bad timestamp external representation '2001-12-04 00.00.00'


the field that causes the error is :

PTDATINS    datetime    8

in AHEPATCH. In this column I have this date : '04/12/2001'. I don't know
which is the problem, can you help me ?

    Samuele.


---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org