/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 votes174 views3 answers
Laravel create get id
PHP Laravel
1 vote155 views1 answer
Laravel doesNotHave in model
PHP Laravel
2 votes186 views2 answers
How get the first item in foreach in laravel
PHP Laravel
0 vote162 views1 answer
Laravel override eloquent all function
PHP Laravel
5 votes206 views3 answers
Display all errors in blade laravel
PHP Laravel
0 vote171 views1 answer
Laravel adding new items to config run time
PHP Laravel
2 votes175 views5 answers
Laravel drop table migration
PHP Laravel
0 vote218 views1 answer
Laravel append parameter to links
PHP Laravel
3 votes173 views1 answer
Laravel RuntimeException Session store not set on request.
PHP Laravel
2 votes193 views2 answers
Create custom rule in laravel
PHP Laravel