/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 vote143 views1 answer
Laravel dusk run failed tests
PHP Laravel
0 vote147 views1 answer
Create fake users on click laravel
PHP Laravel
2 votes137 views3 answers
Laravel public static variable
PHP Laravel
0 vote137 views1 answer
Laravel query builder select first
PHP Laravel
12 votes137 views2 answers
Debug bar laravel print array
PHP Laravel
0 vote159 views1 answer
How to retrieve data from database using select option in laravel
PHP Laravel
0 vote139 views1 answer
Drop foreign key laravel eloquent
PHP Laravel
1 vote298 views1 answer
How to stop laravel server
PHP Laravel
4 votes150 views2 answers
Laravel attach
PHP Laravel
0 vote141 views2 answers
Add blade in blade laravel
PHP Laravel