how to get data with DATE only in laravel?

Question

in approve_date I have date stored in this form 2021-04-28 20:03:00 and i want to fetch all the record from passing 2021-04-28 so i tried this piece of code

Order::whereDate('approve_date' , 2021-04-28)->get()->sum('subtotal');

but the problem is i am getting 0 and in db subtotal(sum) is 700 of 3 rows

Max Siratskyi · Accepted Answer · 2021-04-29 09:08:03Z

1

Try this please:

Order::whereDate('approve_date', '=', new Carbon('2021-04-28'))->get()->sum('subtotal')

I recomend to use DateTime object or Carbon.

PS don't forget to use use Carbon\Carbon;

answered Apr 29, 2021 at 9:08

Max Siratskyi

782 silver badges6 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Friede · Accepted Answer · 2025-03-28 10:52:12Z

-1

Because the date format you stored in database is 2021-04-28 20:03:00 format.

To fetch the record in YYYY-M-D, you first need to parse the DATE to

Order::whereDate('DATE(approve_date)' , 2021-04-28)->get()->sum('subtotal');

edited Mar 28 at 10:52

Friede

11.8k2 gold badges14 silver badges32 bronze badges

answered Apr 29, 2021 at 9:03

Jon Kim

1152 silver badges12 bronze badges

2 Comments

Hamza Qureshi Over a year ago

"SQLSTATE[42S22]: Column not found: 1054 Unknown column 'DATE(approve_date)' in 'where clause' (SQL: select * from orders where date(DATE(approve_date)) = 1989) getting thi serror

Aless55 Over a year ago

for this to work you will have to make a raw statement

Collectives™ on Stack Overflow

how to get data with DATE only in laravel?

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related