[Dbix-class] ANNOUNCE: SQL::Abstract 1.60
Karen Hoofnagle
karen at hoofnagle.org
Tue Sep 22 18:14:08 GMT 2009
As of SQL::Abstract 1.60, the following code now properly supports
using functions with between.
my $rs = $schema->resultset('User_Read_Log')->search(
{
datetime => {
"between",
[
\[ "to_date(?, 'YYYYMMDD HH24:MI:SS')", "$start 00:00:00" ],
\[ "to_date(?, 'YYYYMMDD HH24:MI:SS')", "$end 00:00:00" ]
]
}
Thanks so much Peter and Will and everyone who responded. I'll see
about propagating this example to the cookbook.
Karen
More information about the DBIx-Class
mailing list