<html><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">Hi<div><br></div><div>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:</div><div><br></div><div><div> my $processes = $schema->resultset('Process')<span class="Apple-style-span" style="font-family: monospace; white-space: pre; "><span class="Apple-style-span" style="font-family: Helvetica; white-space: normal; ">->search(</span></span></div><div><span class="Apple-tab-span" style="white-space:pre"> </span>{date_created => {</div><div><div> '>=' => $dt_min_date,</div><div><span class="Apple-tab-span" style="white-space:pre"> </span> '<=' => $sdt_max_date</div></div><div><span class="Apple-tab-span" style="white-space:pre"> </span>}}</div><div> );</div><div><br></div><div>However, the DT objects are simply stringified. So is there a DB generic way?</div><div><br></div><div>Thanks</div></div></body></html>