/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

-2 votes318 views3 answers
Laravel where condition with if
PHP Laravel
1 vote295 views4 answers
Laravel generate slug
PHP Laravel
1 vote384 views1 answer
Get year in laravel 8
PHP Laravel
0 vote358 views1 answer
Laravel search user details by specific role
PHP Laravel
1 vote360 views1 answer
Clear cache using laravel controller
PHP Laravel
0 vote305 views1 answer
Function inside model laravel
PHP Laravel
2 votes321 views2 answers
Laravel arrays
PHP Laravel
3 votes323 views3 answers
Laravel sort by function'
PHP Laravel
0 vote345 views1 answer
Laravel seeding with relationships
PHP Laravel
1 vote343 views1 answer
Laravel dynamic page title
PHP Laravel