/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

2 votes233 views1 answer
When image update laravel delete remove image
PHP Laravel
1 vote272 views1 answer
Add checkbox in server side datatable laravel
PHP Laravel
3 votes213 views3 answers
Loop index foreach laravel
PHP Laravel
0 vote235 views1 answer
How to get meta information from pagination in laravel controller
PHP Laravel
4 votes214 views2 answers
Laravel request all delete _token
PHP Laravel
25 votes214 views6 answers
Laravel carbon date format
PHP Laravel
0 vote176 views1 answer
Laravel showing index of problem
PHP Laravel
3 votes219 views2 answers
Insert into laravel 8
PHP Laravel
9 votes196 views3 answers
How to get orinal hash laravel
PHP Laravel
7 votes225 views3 answers
Laravel creat new model
PHP Laravel