[Koha-bugs] [Bug 16371] Quote of the Day (QOTD) for the staff interface

[bugzilla-daemon at bugs.koha-community.org]

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

--- Comment #69 from Jonathan Druart <jonathan.druart at bugs.koha-community.org> ---
(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.