/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

1 vote344 views3 answers
Laravel get input from request
PHP Laravel
3 votes348 views2 answers
Laravel collection concat
PHP Laravel
0 vote402 views1 answer
Use app http models in laravel 8
PHP Laravel
1 vote385 views1 answer
Laravel 8 validation required if another field is not null
PHP Laravel
0 vote367 views2 answers
Steps to create laravel project
PHP Laravel
0 vote388 views2 answers
Str lower laravel
PHP Laravel
14 votes349 views6 answers
Laravel debug
PHP Laravel
0 vote379 views1 answer
Laravel collection higher order messages
PHP Laravel
3 votes355 views1 answer
Laravel inrandomorder
PHP Laravel
0 vote346 views2 answers
General error: 1215 Cannot add foreign key constraint laravel
PHP Laravel