/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

13 votes134 views3 answers
Laravel string
PHP Laravel
0 vote149 views1 answer
Get data from model in chunks laravel
PHP Laravel
0 vote153 views1 answer
Validate audio file in laravel
PHP Laravel
9 votes163 views6 answers
Laravel current url
PHP Laravel
0 vote164 views6 answers
Laravel tips
PHP Laravel
5 votes172 views1 answer
Laravel get random row
PHP Laravel
0 vote152 views2 answers
Laravel allow all fillable
PHP Laravel
0 vote102 views1 answer
How convert the string to int in laravel function event
PHP Laravel
2 votes184 views1 answer
Laravel 8 delete by id
PHP Laravel
0 vote158 views1 answer
Add variables to line in laravel notification
PHP Laravel