/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 vote318 views1 answer
Laravel mcq questions
PHP Laravel
2 votes367 views6 answers
Get last id in laravel
PHP Laravel
0 vote348 views1 answer
Laravel move file from local to s3
PHP Laravel
1 vote342 views2 answers
Upload a pdf file laravel
PHP Laravel
2 votes351 views1 answer
Laravel difference between current time and created time
PHP Laravel
0 vote327 views1 answer
Creer un modele laravel
PHP Laravel
8 votes333 views1 answer
Object not found in laravel xampp
PHP Laravel
1 vote305 views2 answers
Laravel collection implode
PHP Laravel
0 vote319 views1 answer
Error: Class '\App\Models\User' not found in file D:\teraNinga\mazadat\vendor\laravel\framework\src\Illuminate\Auth\EloquentUserProvider.php on line 183
PHP Laravel
9 votes321 views3 answers
Laravel validation image or file
PHP Laravel