Reading date '0000-00-00' from db results in conversion exception

[analogue]

A date value of 0000-00-00 is apparently valid in mysql. When attempting to read this value from the db, a conversion exception is thrown.

'Could not convert '0000-00-00' to python datetime.date'

From a compatibility perspective, the MySQLdb python bindings which uses the native _mysql.so handles this fine and returns the earliest date possible. Something like '1970-01-01' I think.

I would be nice when dropping in the pure python implementation, that it would behave the same as the native version of the python bindings.

[Geert JM Vanderkelen (geertjmvdk)]

Yes, but return 1970-01-01 is also wrong. That's incorrect data.
I'll check this further out. We have to return something, but the year 0000 is not 1970 :)

Thanks for the report!

[Geert JM Vanderkelen (geertjmvdk)]

MySQLdb returns None for DATETIME columns set to '0000-00-00 00:00:00' and DATE set to '0000-00-00'.

I'm going to follow that and make sure that we follow MySQL specifications, just like MySQLdb appears to be doing, which is good!

http://dev.mysql.com/doc/refman/5.1/en/datetime.html