/PHP/Laravel/How to calculate age using query builder in laravel?

How to calculate age using query builder in laravel?

You can use selectRaw and then use mysql function like this

$user_info = DB::table('users')
                ->selectRaw("TIMESTAMPDIFF(YEAR, DATE(dob), current_date) AS age")
                ->get();

Source: stackoverflow.com

Similar codes

0 vote246 views1 answer
Appserviceprovider laravel auth user
PHP Laravel
44 votes237 views6 answers
How to make controller in laravel
PHP Laravel
0 vote247 views1 answer
Laravel Http client retry request if fail
PHP Laravel
53 votes271 views6 answers
Laravel run seed
PHP Laravel
0 vote232 views5 answers
Date format change in laravel
PHP Laravel
5 votes261 views5 answers
Table drop foreign php laravel
PHP Laravel
4 votes242 views2 answers
Switch in laravel
PHP Laravel
1 vote240 views1 answer
Forenkey set inlaravel 8
PHP Laravel
0 vote241 views1 answer
Laravel create mode
PHP Laravel
0 vote250 views1 answer
Formate date using carbon in laravel blade
PHP Laravel