Bug #30009 create and execute a date-field
Submitted: 24 Jul 2007 15:43 Modified: 24 Jul 2007 18:54
Reporter: Karl-Heinz Kopp Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server: Data Types Severity:S3 (Non-critical)
Version: OS:Linux
Assigned to: CPU Architecture:Any

[24 Jul 2007 15:43] Karl-Heinz Kopp 
Description:
A date-field which is filled with the value "2007-06-31" whould be saved as value "0000-00-00".

The field was declared "st date default null,".

I have installed MySQL-server-community-5.0.45-0.sles9.i586.rpm and
MySQL-client-community-5.0.45-0.sles9.i586.rpm

In earlier version there where no problems with the same code.

How to repeat:
A date-field which is filled with the value "2007-06-31" whould be saved as value "0000-00-00".
[24 Jul 2007 18:54] Sveta Smirnova 
Thank you for taking the time to write to us, but this is not a bug. Please double-check the documentation available at http://dev.mysql.com/doc/ and the instructions on
how to report a bug at http://bugs.mysql.com/how-to-report.php

Please read about changes made in version 5.0.2 at http://dev.mysql.com/doc/refman/5.0/en/datetime.html