I want to store the age of an individual (I cannot use DOB) and for this the years, months or days values may be 0. Therefore I am using a DateTime::Duration object. Thing is the plugin will fail if the value is not a valid date (and 0020-08-00 is not valid). Can I use the plugin, do I have to write my own or is there another way?

(BTW MySQL does allow such values - I am not concerned if it is 'invalid' - it works for what I need and I am not planning to change my RDBMS.)

Thinking about it some more, and discussing on #dbix-class, it looks like I need a better serializer than a datetime column. I'm looking at using DateTime::Format::Duration::XSD and writing my own inflatecolumn component based on that
–
cubabitJun 17 '10 at 8:47