/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

9 votes203 views2 answers
A facade root has not been set laravel
PHP Laravel
4 votes194 views3 answers
Laravel use config
PHP Laravel
1 vote215 views3 answers
Laravel api enable cors
PHP Laravel
0 vote229 views3 answers
Factory laravel tinker
PHP Laravel
0 vote206 views1 answer
How to use attempt in laravel
PHP Laravel
0 vote209 views1 answer
Laravel check if form has errors
PHP Laravel
1 vote202 views3 answers
Laravel eloquent bulk insert
PHP Laravel
4 votes205 views1 answer
Laravel install production
PHP Laravel
0 vote187 views2 answers
Laravel has one through relationship
PHP Laravel
0 vote191 views1 answer
Copy file from one directory to another Laravel
PHP Laravel