How to get birthdate in Laravel?

Question

I want to show the value of first_name and birth_date of customers who were birthday today. What kind of queries should I do?

  $birthday = DB::table('customers')
  ->select(DB::raw('customers.first_name','customers.birth_date'))
  ->whereRaw('DAYOFYEAR(curdate()) <= DAYOFYEAR(birth_date) AND DAYOFYEAR(curdate()) + 0 >=  dayofyear(birth_date)')
  ->orderByRaw('DAYOFYEAR(birth_date)')
  ->get();

score 0 · Answer 1 · answered Feb 11 '20 at 13:05

0

You can use this:

 $birthday = DB::table('customers')
  ->select(DB::raw('customers.first_name','customers.birth_date'))
  ->whereRaw("DATE_FORMAT(FROM_UNIXTIME(birth_date),'%m-%d') = DATE_FORMAT(NOW(),'%m-%d')")
  ->orderByRaw('DAYOFYEAR(birth_date)')
  ->get();

Reference: Use MySQL to determine whether today is a user's birthday

answered Feb 11 '20 at 13:05

Sehdev

5,486
3
11
34

I can query in databsae, but cannot query on php. – CyberAceTrevor Feb 11 '20 at 13:17
why do you want to use php for fetching today's birthdays? – Sehdev Feb 11 '20 at 13:19
I want to display the birthday value of my customers in my admin console to let staff know. – CyberAceTrevor Feb 11 '20 at 13:34
This query will returns all the customers having b'dy today. You can easily show those customers using $birthday->birth_date – Sehdev Feb 11 '20 at 15:32

Jasmel Singh · Answer 2 · 2020-02-12T02:29:23.300

0

You can get the results by using the following query...

$today = \Carbon\Carbon::today()->toDateString();

$birthday = DB::table('customers')
    ->select('customers.first_name','customers.birth_date')
    ->whereDate('birth_date', $today)
    ->get();

edited Feb 12 '20 at 02:29

answered Feb 11 '20 at 16:23

Jasmel Singh

111
1
6

How to get birthdate in Laravel?

2 Answers2