DATE(datecolumns) = '2018-12-24'
это убийца производительности:SELECT * FROM tablename
WHERE columname BETWEEN '2018-12-25 00:00:00' AND '2018-12-25 23:59:59'
SELECT * FROM tablename
WHERE columname >='2018-12-25 00:00:00'
AND columname <'2018-12-26 00:00:00'
R::addDatabase('DB1','sqlite:/tmp/d1.sqlite',
'user','password',$frozen);
R::selectDatabase('DB1');
R::selectDatabase('default');