/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

0 vote184 views1 answer
Show images laravel 8 showJobImage($filename)
PHP Laravel
2 votes152 views1 answer
Comments table example in laravel
PHP Laravel
0 vote130 views1 answer
Laravel, if ->get() array is not emtpy
PHP Laravel
1 vote213 views1 answer
--prefer-dist what is use in laravel
PHP Laravel
0 vote212 views1 answer
Macos how host laravel website on localhost and intranet wifi
PHP Laravel
9 votes206 views3 answers
Laravel enum migration example
PHP Laravel
0 vote195 views1 answer
Laravel - Comparison betweeon two column values - whereColumn
PHP Laravel
-1 vote193 views1 answer
Laravel orderby with relation
PHP Laravel
9 votes168 views3 answers
Laravel database seeder medium
PHP Laravel
0 vote195 views1 answer
Check laravel first null
PHP Laravel