How to get data from database using date?

Question

I want to selecting and showing data based on current date. I have made query selected for this, but it not working

this is my date data on table :

a busy cat

this is my query:

$now = date('Y-m-d');
$trans = FA_transaction::where('assign_date', $now)->get();

when i execute the query, i don't get any data

Possible duplicate of Laravel Eloquent compare date from datetime field — Nikhil G
– Nikhil G, Commented Feb 18, 2019 at 6:53

Mihir Bhende · Accepted Answer · 2019-02-18 07:03:28Z

2

You can do :

$trans = FA_transaction::whereDate('date', Carbon::today())->get();

OR if you want to use MySQL's CURDATE function, you can do :

$trans = FA_transaction::->whereRaw('Date(date) = CURDATE()')->get();

answered Feb 18, 2019 at 7:03

Mihir Bhende

9,0952 gold badges33 silver badges39 bronze badges

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

3 Comments

Rahmat Effendi Over a year ago

hello @MihirBhende, when i add where('worker_id', $getWorker->id) like this

$trans = FA_transaction::where('worker_id', $getWorker->id)                                  ->whereDate('assign_date', Carbon::today())                                  ->get();

I don't get any data also

Mihir Bhende Over a year ago

Does it contain any data for the particular selection. Also do you have timezones in your system?

Rahmat Effendi Over a year ago

thanks @MihirBhende, i found my mistake, and it working now

Haider Ali · Accepted Answer · 2019-02-18 06:56:38Z

1

You can use whereDate function to filter out records based on date try this!

$now = date('Y-m-d');
$trans = FA_transaction:: whereDate('date','=',$now)->get();

answered Feb 18, 2019 at 6:56

Haider Ali

1,1218 silver badges23 bronze badges

Comments

Zahid Hassan Shaikot · Accepted Answer · 2019-02-18 07:20:40Z

1

You can use it

 $now = Carbon::today();
 $trans = FA_transaction::where('assign_date', $now)->get();

OR

 $now = Carbon::now()->format('Y-m-d');
 $trans = FA_transaction::where('assign_date', $now)->get();

answered Feb 18, 2019 at 7:20

Zahid Hassan Shaikot

1,3581 gold badge11 silver badges19 bronze badges

3 Comments

Rahmat Effendi Over a year ago

hello, i have tried your code and work. and i have another select data with different query like this

$trans = FA_transaction::where('worker_id', $getWorker->id)                                  ->whereDate('assign_date', Carbon::today())                                  ->get();

when i execute it, i don't got any data also

Zahid Hassan Shaikot Over a year ago

is it showing any error or empty?if it showing empty then check your input 1st

Zahid Hassan Shaikot Over a year ago

please share the full table

Collectives™ on Stack Overflow

How to get data from database using date?

3 Answers 3

3 Comments

Comments

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related