[Catalyst] SQLite Dates

John Siracusa siracusa at mindspring.com
Sat Mar 18 01:21:52 CET 2006


On 3/17/06 6:47 PM, apv wrote:
> How are you (any of you) dealing with NULL dates? All of the auto-inflating on
> dates I've tried blows up in that case b/c "0000-00-00 00:00:00" is not a
> valid date.

I use NULLs for null dates.  When forced to use a database that allows such
things, I treat "non-dates" like "0000-00-00" as literal keywords so they
round-trip without damage.  Values like that are pretty much useless to me
on the Perl side, so preserving them is about the best I can expect to do.

-John





More information about the Catalyst mailing list