https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16371 --- Comment #69 from Jonathan Druart <jonathan.druart@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.