/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

50 votes392 views6 answers
Laravel migration add column to existing table
PHP Laravel
0 vote303 views1 answer
Laravel blade dynamic class loop foreach
PHP Laravel
0 vote295 views1 answer
Laravel Pusher 401 Unauthorized
PHP Laravel
1 vote336 views2 answers
Laravel maximum execution time of 30 seconds exceeded
PHP Laravel
0 vote263 views1 answer
Laravel where false
PHP Laravel
1 vote311 views1 answer
How to add attribute to the request object in laravel
PHP Laravel
0 vote412 views1 answer
Schema key issue laravel
PHP Laravel
0 vote292 views1 answer
Laravel chain query builder
PHP Laravel
1 vote296 views2 answers
Laravel 8 selecet the 2nd to the last record
PHP Laravel
10 votes276 views2 answers
Laravel route list
PHP Laravel