[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