Created at date only

You can do something like this

->where(DB::raw('CURDATE(created_at)'), '=', Carbon::now()->format('Y-m-d'))->sum('eaten_calories');

Or

->where('created_at', Carbon::today())->sum('eaten_calories');

So many options here!

@bobbybouwmann query not working syntax error

select sum(`eaten_calories`) as aggregate from `diet_takens` where `user_id` = 15 and CURDATE(created_at) = 2015-08-15

@LovelyBoy I'd do what jekinney did but modify it a bit.

 $takendiet = DietTaken::where('user_id',$auth_id)
    ->where('created_at', '>=', Carbon::today())
    ->where('created_at', '<', Carbon::tomorrow())
    ->sum('eaten_calories');

@thomaskim thanks its works:)

@thomaskin isn't your query end up the same as what I posted?

Just got me thinking. The today method returns todays date with out time. So it looks for all created at with todays date only.

@jekinney Your answer makes more sense here, but the OP is happy with it... I guess

@LovelyBoy There’s a query builder method exactly for this:

DietTaken::where('user_id', '=', $auth_id)
         ->whereDate('created_at', '=', Carbon::today())
         ->sum('eaten_calories');

I was curious on the difference.

@martinbean Great stuff. I wasn't aware of that.

@jekinney Wouldn't your original query only find ones that were created today at the time 00:00:00?

Curiosity got me....

$takendiet = DietTaken::where('user_id',$auth_id)
    ->where('created_at', '>=', Carbon::today())
    ->where('created_at', '<', Carbon::tomorrow())
    ->sum('eaten_calories');

returns the same as

$takendiet = DietTaken::where('user_id',$auth_id)
    ->where('created_at', '=', Carbon::today())
    ->sum('eaten_calories');

The reason I was thinking was the first query compares created_at by greater then and equal to today's date on the first where then compares created_at is less then tomorrows date, which is the same as equals today's date only as per the second query. It had me wondering is all what the difference was. Other then being less efficient, it is ultimately the same query as they return the exact same results.

@thomaskin

Carbon::today()

only returns the date no time. So the date comparison will compare date not time. I know as I have used that query a lot for graph data for backend to show sign ups, subscriptions etc