/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

3 votes118 views4 answers
Csrf token mismatch laravel api
PHP Laravel
1 vote119 views1 answer
Invalid datetime format laravel
PHP Laravel
0 vote149 views1 answer
Laravel mixed content error
PHP Laravel
1 vote118 views1 answer
Laravel dusk run failed tests
PHP Laravel
0 vote130 views1 answer
Laravel new project command doesn't create vendor
PHP Laravel
0 vote129 views1 answer
Laravel create new file if not exists
PHP Laravel
3 votes119 views1 answer
Date time laravel
PHP Laravel
5 votes118 views3 answers
Laravel get view variables
PHP Laravel
4 votes117 views3 answers
Softdeletes laravel
PHP Laravel
2 votes127 views1 answer
Return back in blade laravel
PHP Laravel