/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 vote233 views1 answer
Doiffernce between text and string in laravel migration
PHP Laravel
3 votes213 views2 answers
Current user laravel
PHP Laravel
0 vote363 views1 answer
Parameter to laravel seeder
PHP Laravel
0 vote230 views1 answer
Laravel find model inside the same model
PHP Laravel
0 vote240 views1 answer
Make controller laravel history open link
PHP Laravel
1 vote247 views3 answers
Laravel check if collection has value
PHP Laravel
0 vote274 views2 answers
New static laravel
PHP Laravel
0 vote161 views0 answer
Laravel
PHP Laravel
6 votes217 views3 answers
Laravel 8 with jetstream
PHP Laravel
20 votes229 views6 answers
Laravel validation types
PHP Laravel