Re: [pgadmin-hackers] pgMigrate

[Dave Page]

> -----Original Message-----
> From: Brett Maton [mailto:[EMAIL PROTECTED]] 
> Sent: 12 January 2002 14:49
> To: [EMAIL PROTECTED]
> Subject: RE: [pgadmin-hackers] pgMigrate
> 
> 
> Hi Dave,
> 
>   Thanks for the letting me know about the logs, guess I 
> should have looked 
> around a little more ;).  I did find the offending field not 
> sure how they 
> managed to get that value in thier in the first place!
> 
> Looking through the log though it would appear that the 
> Access Date/Time 
> field is out put as dd/mm/yy in single quotes.  Is this 
> affected by the 
> format value setup in the Access DB ?

Hi Bret,

I've committed a fix to CVS that should sort this. All dates are reformatted
to yyyy-MM-dd hh:mm:ss which is unambiguous. The VB Format function will
also prefix 1899-12-30 automatically for MS Access date fields that only
actually contain the time (I'm sure this must be broken behaviour on the
part of Access, but it happens a lot so we need to handle it somehow).

Regards, Dave.