Bug #17207 driver throws SQL exception parsing a timestamp
Submitted: 7 Feb 2006 22:08 Modified: 7 Feb 2006 22:27
Reporter: [ name withheld ] Email Updates:
Status: Not a Bug Impact on me:
Category:Connector / J Severity:S3 (Non-critical)
Version: OS:
Assigned to: CPU Architecture:Any

[7 Feb 2006 22:08] [ name withheld ]
MySQL appears to allow the following value for a timestamp field '0000-00-00', however the jdbc driver throws an exception when trying to parse this value.

How to repeat:
just insert a date value of '0000-00-00' and try to get the value from a result set.

Suggested fix:
not sure
[7 Feb 2006 22:27] Mark Matthews
See the manual - http://dev.mysql.com/doc/refman/5.0/en/cj-upgrading.html explains why this happens, and what to do to correct it.