https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16371

--- Comment #69 from Jonathan Druart <[email protected]> 
---
(In reply to Jonathan Druart from comment #68)
> (In reply to Emmi Takkinen from comment #67)
> > (In reply to Jonathan Druart from comment #66)
>  70                 timestamp => { -like => "$dt%" },
> 
> This is a bit unusual to me, but I cannot think of something else (apart
> from using \'CAST() that is not better). I will ask a couple of QAers how we
> should do that.

We got an answer from #dbix-class, we should use -between => [ "$dt 00:00:00",
"$dt 23:59:59" ], to be DB agnostic and allow use of indexes.
$dt must be generated using $dtf->format_date.

-- 
You are receiving this mail because:
You are watching all bug changes.
_______________________________________________
Koha-bugs mailing list
[email protected]
https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/

Reply via email to