Bug #25386 | Cannot update TIMESTAMP or DATE columns | ||
---|---|---|---|
Submitted: | 3 Jan 2007 13:15 | Modified: | 23 Jan 2007 14:20 |
Reporter: | Tim Salter | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | Connector / ODBC | Severity: | S2 (Serious) |
Version: | 3.51.12 | OS: | Windows (Windows XP) |
Assigned to: | MC Brown | CPU Architecture: | Any |
Tags: | access, date, ODBC, timestamp |
[3 Jan 2007 13:15]
Tim Salter
[3 Jan 2007 16:46]
MySQL Verification Team
Thank you for the bug report. That is a known issue with Access, please see http://dev.mysql.com/doc/refman/5.1/en/myodbc-errors.html#qandaitem-26-1-6-3-7. Thanks in advance.
[3 Jan 2007 20:16]
Tim Salter
Re the workround, in addition to the documented requirements, the timstamp field must be set to a non-null, not zero (i.e. not '000-00-00 00:00:00' value in order for it to work.
[23 Jan 2007 14:20]
MC Brown
I've added a new question/answer combination to the documentation that deals specifically with this issue.