in reply to Class::DBI - MySQL - DateTime

MySQL doesn't store NULL as '0000-00-00 00:00:00' -- it stores it as NULL. Take the NOT NULL constraint off that column so you ca have actual NULLs in it and then everything will work.

Replies are listed 'Best First'.
Re^2: Class::DBI - MySQL - DateTime
by bpphillips (Friar) on Jun 07, 2005 at 14:46 UTC
    That's an excellent point -- and one I didn't think about. It does appear to work as I need it to. Thanks!