/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

17 votes308 views3 answers
Laravel make model controller and migration one time
PHP Laravel
0 vote255 views1 answer
Laravel interview questions
PHP Laravel
0 vote284 views1 answer
Artisan::call for all catch clear in laravel
PHP Laravel
4 votes260 views3 answers
Laravel on delete set null
PHP Laravel
0 vote236 views1 answer
Laravel eloquent return array where
PHP Laravel
1 vote345 views1 answer
How to stop laravel server
PHP Laravel
-1 vote256 views1 answer
Laravel orderby with relation
PHP Laravel
10 votes233 views2 answers
Laravel success message
PHP Laravel
8 votes247 views2 answers
Laravel passport client
PHP Laravel
5 votes259 views2 answers
Get app url in laravel
PHP Laravel