Re: pgadmin sql server migration timestamps

> -----Original Message-----
> From: Samuele Brignoli [mailto:samuele(dot)brignoli(at)darpha(dot)com]
> Sent: 15 February 2002 08:51
> To: pgadmin-support(at)postgresql(dot)org
> Subject: [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 ?

Hi,

The error message you are getting actually comes from the PostgreSQL server
- pgAdmin is just displaying it. Basically, it can't understand '2001-12-04
00.00.00' as a timestamp.

I've tried this on my system and get the same result as you, however if I
change the data to '2001-12-04 00:00:00' (which is the standard ISO format)
it works fine.

I would suggest either:

- Adjusting the date format on your SQL system to ISO.

or

- If the . notation is valid for your locale, check with one of the
PostgreSQL mailing lists (probably pgsql-general(at)postgresql(dot)org) to ensure
that your system is setup correctly and that it isn't an actual bug in
PostgreSQL.

Regards, Dave.