/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

0 vote238 views1 answer
Doiffernce between text and string in laravel migration
PHP Laravel
13 votes265 views3 answers
How to change existing migration laravel
PHP Laravel
7 votes259 views5 answers
Jetstream laravel
PHP Laravel
0 vote248 views1 answer
Laravel console example
PHP Laravel
0 vote251 views1 answer
Laravel display the date the participation was created
PHP Laravel
5 votes253 views2 answers
Collection laravel filter
PHP Laravel
0 vote253 views1 answer
Laravel Eloquent, group by month/year
PHP Laravel
-1 vote258 views1 answer
Laravel carbon y-m-d
PHP Laravel
1 vote277 views1 answer
How to add properties to the request object in laravel
PHP Laravel
16 votes263 views5 answers
Laravel blade for loop
PHP Laravel