/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 vote194 views2 answers
Laravel project make
PHP Laravel
0 vote186 views1 answer
Laravel faker title
PHP Laravel
0 vote212 views1 answer
Show float laravel blade
PHP Laravel
0 vote207 views1 answer
Laravel faker boolean
PHP Laravel
0 vote195 views1 answer
How run job laravel in cpanel host
PHP Laravel
-1 vote199 views4 answers
How to include file in laravel blade
PHP Laravel
5 votes204 views4 answers
Laravel model wherein
PHP Laravel
1 vote268 views1 answer
Laravel 8 bootstrap pagination fix
PHP Laravel
0 vote214 views1 answer
Laravel (8) - Routing to controller with optional parameters
PHP Laravel
1 vote204 views1 answer
Call metho din config laravel
PHP Laravel