WHERE 1=1 [[AND date_field >= {{datepicker1}}]]
[[AND date_field <= {{datepicker2}}]]
[[AND DATE(date_field) = {{datepicker3}}]]
--for casting to date type
WHERE 1=1 [[AND date_field >= DATE({{datepicker1}})]]
[[AND date_field <= DATE({{datepicker2}})]]
[[AND DATE(date_field) = DATE({{datepicker3}})]]
--for casting to timestamp type
WHERE 1=1 [[AND date_time >= TIMESTAMP({{datepicker1}})]]
[[AND date_time <= TIMESTAMP({{datepicker2}})]]
[[AND TIMESTAMP(date_time) = TIMESTAMP({{datepicker3}})]]