/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

6 votes320 views4 answers
Laravel create project command
PHP Laravel
1 vote309 views1 answer
How make exception laravel if operation does not work
PHP Laravel
0 vote323 views1 answer
Laravel collection pull
PHP Laravel
0 vote359 views1 answer
Laravel select error
PHP Laravel
0 vote344 views1 answer
Laravel maintenance mode custom class
PHP Laravel
0 vote378 views1 answer
Cannot be cast automatically to type integer laravel
PHP Laravel
0 vote367 views1 answer
Flash message laravel for incorrect password
PHP Laravel
0 vote357 views1 answer
Laravel blade php variable concatenate javascript variable
PHP Laravel
8 votes391 views3 answers
Laravel log query for model
PHP Laravel
0 vote314 views3 answers
@parent laravel
PHP Laravel