/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

3 votes144 views5 answers
Laravel permission
PHP Laravel
0 vote191 views5 answers
Laravel create multiple models at once
PHP Laravel
10 votes148 views4 answers
Import session laravel
PHP Laravel
0 vote141 views1 answer
Laravel faker realtext
PHP Laravel
1 vote154 views1 answer
How get just one parameter of all objects in one array in laravel
PHP Laravel
19 votes150 views6 answers
Query builder laravel
PHP Laravel
0 vote150 views1 answer
Show user only those products which he hasn't buyed laravel eloquent
PHP Laravel
7 votes143 views3 answers
Laravel 8 validation unique 2 columns
PHP Laravel
0 vote149 views1 answer
Laravel query foreach
PHP Laravel
4 votes167 views1 answer
Laravel install production
PHP Laravel