/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 vote197 views1 answer
Laravel role
PHP Laravel
0 vote208 views1 answer
Check if column has value in laravel eloquent
PHP Laravel
0 vote199 views1 answer
Publish Spatie Laravel Permission
PHP Laravel
0 vote208 views1 answer
How to get private images in s3 laravel
PHP Laravel
1 vote313 views1 answer
How to use old for select in blade laravel
PHP Laravel
0 vote211 views1 answer
Laravel find model inside the same model
PHP Laravel
2 votes199 views3 answers
Laravel 8 404 status
PHP Laravel
0 vote200 views1 answer
Laravel vue build production
PHP Laravel
-1 vote202 views1 answer
Echo in console command laravel
PHP Laravel
3 votes257 views2 answers
How to get file extension in laravel
PHP Laravel