/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

4 votes392 views4 answers
Laravel 8 carbon if date is today
PHP Laravel
0 vote370 views2 answers
Laravel form put method
PHP Laravel
0 vote411 views2 answers
Laravel get path to storage folder
PHP Laravel
0 vote384 views2 answers
Value() in laravel
PHP Laravel
6 votes418 views2 answers
Installing livewire on laravel v6
PHP Laravel
0 vote385 views1 answer
Take and skip in laravel
PHP Laravel
1 vote372 views1 answer
Laravel pluralization text
PHP Laravel
3 votes344 views1 answer
Laravel middleware route
PHP Laravel
2 votes331 views1 answer
Redirect on validation error laravel to specific section laravel
PHP Laravel
3 votes346 views2 answers
Laravel check if laravel query is empty
PHP Laravel