/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

7 votes275 views4 answers
UUIDs LARAVEL
PHP Laravel
1 vote255 views1 answer
Laravel update method resource
PHP Laravel
0 vote290 views3 answers
Laravel 7 upload file s3
PHP Laravel
0 vote252 views1 answer
Laravel get header from request
PHP Laravel
1 vote357 views2 answers
Laravel check if email is real
PHP Laravel
1 vote272 views1 answer
Autoload file laravel
PHP Laravel
0 vote241 views1 answer
Laravel connection timed out
PHP Laravel
0 vote256 views1 answer
Laravel blade check if yielded content exists
PHP Laravel
-2 votes284 views1 answer
Laravel model bind with route in model
PHP Laravel
5 votes290 views3 answers
Get users of specific role laravel role spatie
PHP Laravel