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(at)postgresql(dot)org
[mailto:pgadmin-support-owner(at)postgresql(dot)org]Per conto di Samuele
Brignoli
Inviato: venerdì 15 febbraio 2002 9.51
A: pgadmin-support(at)postgresql(dot)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