[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