> -----Original Message-----
> From: Brett Maton [mailto:matonb@hotmail.com]
> Sent: 12 January 2002 14:49
> To: dpage@vale-housing.co.uk
> 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.