/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 vote209 views1 answer
How to add attribute to the request object in laravel
PHP Laravel
0 vote128 views1 answer
Laravel secure route
PHP Laravel
0 vote166 views1 answer
Nuxt auth login with laravel passport
PHP Laravel
1 vote200 views1 answer
Update many laravel
PHP Laravel
0 vote178 views1 answer
Getting key from env returns null laravel
PHP Laravel
7 votes174 views4 answers
How get role of user in laravel spatie
PHP Laravel
0 vote187 views1 answer
Laravel response json status 500
PHP Laravel
0 vote188 views1 answer
Laravel capsule schema datatime CURRENT_TIMESTAMP
PHP Laravel
50 votes481 views6 answers
Laravel migration add column to existing table
PHP Laravel
4 votes172 views2 answers
Numbric validate laravel
PHP Laravel