/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

5 votes259 views2 answers
Laravel collection chunk
PHP Laravel
1 vote273 views1 answer
Laravel bindings query
PHP Laravel
9 votes288 views1 answer
Get data in orderby in laravel
PHP Laravel
50 votes348 views6 answers
Laravel database seeder
PHP Laravel
0 vote274 views1 answer
Laravel bootstrap-auth setup
PHP Laravel
14 votes297 views3 answers
How to convert string to int in php laravel
PHP Laravel
0 vote277 views1 answer
Laravel 8 - get values of url query strings in controller
PHP Laravel
0 vote291 views1 answer
How to clear artisan in laravel
PHP Laravel
0 vote279 views4 answers
How i can send by database table in laravel full calendar
PHP Laravel
0 vote296 views1 answer
How get query logs in laravel
PHP Laravel