/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

6 votes166 views3 answers
How to get parameter from url in laravel blade
PHP Laravel
0 vote194 views1 answer
Old value on edit table laravel 6
PHP Laravel
18 votes170 views6 answers
Laravel routes
PHP Laravel
1 vote196 views2 answers
Laravel session put method
PHP Laravel
21 votes194 views2 answers
Long text in laravel migration
PHP Laravel
3 votes183 views1 answer
Laravel validation number greater than 0
PHP Laravel
0 vote191 views1 answer
Igaster\Laravel Theme\Exceptions\theme Already Exists
PHP Laravel
1 vote208 views1 answer
Static function model laravel
PHP Laravel
0 vote191 views1 answer
Laravel: Validation unique on update
PHP Laravel
1 vote195 views1 answer
Laravel select all except some columns
PHP Laravel