/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 vote133 views1 answer
Laravel use npm package
PHP Laravel
3 votes119 views3 answers
Logout in laravel 8
PHP Laravel
2 votes122 views2 answers
Laravel websockets
PHP Laravel
0 vote126 views1 answer
Parameters inside Laravel localized string
PHP Laravel
8 votes142 views4 answers
Get single column value in laravel eloquent
PHP Laravel
0 vote121 views2 answers
Laravel loop variable
PHP Laravel
0 vote118 views4 answers
Laravel collection contains
PHP Laravel
31 votes121 views6 answers
Update or create laravel
PHP Laravel
0 vote126 views1 answer
Publish Spatie Laravel Permission
PHP Laravel
0 vote128 views1 answer
Get return value from another function laravel
PHP Laravel