peterlaursen wrote on Jun 29 2007, 03:06 PM:
It is the ODBC driver that returns 'SQL_TYPE_TIMESTAMP' for the datatype.
There will always be issues with such datatypes that are not identical on different systems!
We have described the issue here:
http://webyog.com/faq/17_125_en.html
I think we chose the best option!
Hi Thanks for the info.
I understand, and agree that timestamp is normally the best option. And was not suggesting that it be changed as the default.
I was just simply wondering if there was a way of changing this behavior temporarily. But that is fine, I will manually change the column mappings for the tables / columns that it effects.
Thanks for taking the time to respond.
Cheers,
Jason