/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

4 votes329 views3 answers
Laravel get auth user in constructor
PHP Laravel
0 vote301 views1 answer
Laravel convert eloquent collection to collection
PHP Laravel
1 vote314 views1 answer
Increment single column laravel
PHP Laravel
28 votes310 views6 answers
Laravel make model with migration
PHP Laravel
0 vote281 views1 answer
Laravel route match
PHP Laravel
0 vote225 views1 answer
Laravel eloquent mass assignments
PHP Laravel
1 vote314 views1 answer
How to store an image in laravel directly from url
PHP Laravel
1 vote321 views1 answer
How to add attribute to the request object in laravel
PHP Laravel
33 votes281 views6 answers
Migrate specific migration laravel
PHP Laravel
0 vote317 views1 answer
Laravel share on whatsapp link
PHP Laravel