Re: pgadmin sql server migration timestamps

[Dave Page]

> -----Original Message-----
> From: Samuele Brignoli [mailto:[EMAIL PROTECTED]] 
> Sent: 15 February 2002 08:51
> To: [EMAIL PROTECTED]
> 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 [EMAIL PROTECTED]) to ensure
that your system is setup correctly and that it isn't an actual bug in
PostgreSQL.

Regards, Dave.