/PHP/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

-2 votes190 views3 answers
Laravel where condition with if
PHP
0 vote172 views1 answer
How to print image just on side where upload php
PHP
0 vote171 views1 answer
Show phpinfo just modules
PHP
-1 vote170 views1 answer
Php sql insert into if not exists
PHP
2 votes141 views2 answers
Laravel custom paginator links view
PHP Laravel
2 votes205 views2 answers
Get relationship data from soft delete laravel
PHP Laravel
24 votes170 views2 answers
Php artisan php warning require
PHP
-1 vote181 views1 answer
Toast in laravel
PHP Laravel
2 votes156 views2 answers
Laravel get public path url
PHP
1 vote151 views1 answer
Remove all attributes from HTML tags in PHP
PHP