[Dbix-class] Database generic dates in where clause

Peter Rabbitson rabbit+dbic at rabbit.us
Thu Jul 2 05:08:31 GMT 2009


Dan Horne wrote:
> 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?

http://rt.cpan.org/Public/Bug/Display.html?id=43075 Or in other words -
you have to do it manually for now. I'm sorry.



More information about the DBIx-Class mailing list