in reply to Re: Date subtraction (intervals) w/Class::DBI
in thread Date subtraction (intervals) w/Class::DBI

I can't generally use built-in functions with Class::DBI because when it builds queries, it puts quotes around everything, so if I try to set the field like:

{created_on => 'NOW()'}

It will translate that to:

SET created_on = 'NOW()'

Which is a string and will error out (note the quotes). It's a severe limitation of Class::DBI, but one I don't have time to fix right now.