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.
Comment on
Re: Class::DBI - MySQL - DateTime
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!
[reply]
In Section
Seekers of Perl Wisdom