/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 vote372 views1 answer
Blade check user role laravel
PHP Laravel
1 vote337 views1 answer
Laravel @canany
PHP Laravel
0 vote350 views1 answer
Laravel collection partition
PHP Laravel
0 vote366 views4 answers
Laravel pluck relationship
PHP Laravel
1 vote374 views1 answer
Laravel child relation order by desc
PHP Laravel
8 votes374 views4 answers
Laravel unique validation on multiple columns
PHP Laravel
4 votes430 views1 answer
Laravel before migration
PHP Laravel
0 vote386 views1 answer
Laravel use npm package
PHP Laravel
0 vote388 views1 answer
How to index column in laravel
PHP Laravel
0 vote364 views1 answer
Laravel echo server
PHP Laravel