/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

5 votes329 views5 answers
Unique laravel migration
PHP Laravel
1 vote288 views1 answer
Laravel validation types for float
PHP Laravel
31 votes293 views2 answers
Laravel sample controller
PHP Laravel
9 votes362 views4 answers
Convert laravel hash password online
PHP Laravel
0 vote354 views4 answers
Laravel upload image
PHP Laravel
2 votes306 views2 answers
Laravel insert timestamp now
PHP Laravel
1 vote316 views2 answers
Explode function in laravel
PHP Laravel
0 vote317 views3 answers
Laravel transform object to array
PHP Laravel
3 votes321 views1 answer
Laravel cannot create an instance of class viewmodel
PHP Laravel
1 vote279 views2 answers
Laravel model fillable vs guarded
PHP Laravel