[Dbix-class] how to search by date?

[Michael Higgins]

Shouldn't this datetime cast/conversion thing be automagical?

    eval { $rs = $schema->resultset('DB::DATA')->search(
                        {Name  => {'like', $name_like},
                     "the date" => \"= cast ('01/4/2008' as datetime)"
                     })};

I just can't figure out, I'm sure, where the syntax is documented for
searching by datetime-type of column data via DBIx::Class.

Any pointers greatly appreciated.

Cheers,

-- 
 |\  /|        |   |          ~ ~  
 | \/ |        |---|          `|` ?
 |    |ichael  |   |iggins    \^ /
 michael.higgins[at]evolone[dot]org