/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 vote126 views1 answer
RequestCriteria laravel
PHP Laravel
0 vote126 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
0 vote119 views1 answer
Laravel get header from request
PHP Laravel
0 vote137 views1 answer
Laravel Validate unique column
PHP Laravel
0 vote125 views2 answers
Laravel blade empty
PHP Laravel
38 votes126 views6 answers
Create seed file laravel
PHP Laravel
2 votes131 views1 answer
Laravel delete confirm link
PHP Laravel
0 vote132 views1 answer
Laravel nginx
PHP Laravel
8 votes74 views2 answers
Laravel password hash online
PHP Laravel
0 vote126 views1 answer
Laravel faker value or null
PHP Laravel