[RDBO] problem with MySQL date and datetime columns

[Uwe Voelker]

Hello John,

it's "the ugly" MySQL again ;-)

Given this schema:

CREATE TABLE `DATUM` (
  `ID` int(10) unsigned NOT NULL auto_increment,
  `DATUM` datetime NOT NULL default '0000-00-00 00:00:00',
  `DATUM2` date NOT NULL default '0000-00-00',
  PRIMARY KEY  (`ID`)
)



I know what you'll say: make the column 'NULL' and it works this way.




Thanks,
bye, Uwe

I can not save a record without DATUM or DATUM2. See attached script. The errormessage is "Column 'DATUM2' cannot be null". But: When you load such an object you correctly map '0000-00-00' to undef. Why can't it be the other way too? Saving 'undef' maps to '0000-00-00'.

date-save.pl
Description: Perl program