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 ?

It shouldn't be. ADO/DAO/RDO/Jet etc are fairly clever and will normally
figure out a date as long as it's in a reasonable format. I'm not sure
pgMigration is doing quite what it should though, but then, I'm not 100%
sure what is correct here either. I'll think about it some more.

Regards, Dave.