convert date/time format to a date only in a query

Question

The following is the required date format :

$sel_date = date('Y-m-d');

But the created_at field has the full date/time format :

2019-10-15 16:14:18

I need to add to the query only the date by omitting the time, as below :

->where('created_at', $sel_date )

Answer 1

Try this:

->whereDate('created_at', $sel_date)

Some documentation about additional where queries here.

Answer 2

you can use date() function of mysql.

->where('date(created_at)', $sel_date )

Answer 3

use the following

CAST("2017-08-29" AS DATE)

ref here