pgadmin sql server migration timestamps

From: "Samuele Brignoli" <samuele(dot)brignoli(at)darpha(dot)com>
To: <pgadmin-support(at)postgresql(dot)org>
Subject: pgadmin sql server migration timestamps
Date: 2002-02-15 08:50:52
Message-ID: CNEDLAJNHCDEGDBGOHHCGEEACLAA.samuele.brignoli@darpha.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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.

In response to

  • Re: Logo at 2002-02-14 19:33:44 from Dave Page

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Dave Page 2002-02-17 20:24:45 Re: pgadmin sql server migration timestamps
Previous Message Dave Page 2002-02-14 19:33:44 Re: Logo