Hi

Perhaps I'm using the wrong query when searching the archive, but I can't find a way to use non-db-specfic dates in a where clause. Since my date columns are defined as dateinflating/deflating, I hoping I could use DateTime objects, but I'm guess that only happens when dates are retrieved or inserted:

    my $processes = $schema->resultset('Process')->search(
        {date_created => {
            '>=' => $dt_min_date,
            '<=' => $sdt_max_date
        }}
    );

However, the DT objects are simply stringified. So is there a DB generic way?

Thanks
_______________________________________________
List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
Searchable Archive: http://www.grokbase.com/group/[email protected]

Reply via email to