/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

11 votes156 views6 answers
Datetime validation in laravel
PHP Laravel
12 votes156 views4 answers
Bcrypt laravel
PHP Laravel
0 vote110 views2 answers
Laravel restrict home route access
PHP Laravel
2 votes172 views5 answers
Laravel installation in windows
PHP Laravel
8 votes160 views1 answer
Laravel custom attributes
PHP Laravel
6 votes176 views4 answers
Return message in laravel
PHP Laravel
1 vote167 views1 answer
Laravel pluralization text
PHP Laravel
0 vote165 views4 answers
Laravel 8: bootstrap
PHP Laravel
0 vote156 views1 answer
Laravel create project with auth 2021
PHP Laravel
16 votes188 views5 answers
Laravel blade for loop
PHP Laravel