[KLUG Members] MySQL and Date Fields

[Michael Lueck]

OK, I looked up the old posting. The grumble of Windows apps via the ODBC
driver to MySQL was as follows:

>>
If I post the times 01:00:00 or 00:45:00 it either refuses to post them or
posts the latter as 45:00:00!
<<

Which the answer was...

>>
Using MyODBC 2.5, tables copied fine, and all of the data types did as
well.  Using ODBC 3.5, date/time columns translated as VARCHAR.  I
wouldn't be surprised if there were other gotchas.
<<

With MySQL 4.1 current, v5 coming... dropping back to a 2.5 ODBC driver seems
just a tad extreme to me in order to get date/time cols to work properly.
Anyway, I guess testing current code will tell the truth!

Michael Lueck
Lueck Data Systems
http://www.lueckdatasystems.com/