/PHP/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 vote106 views2 answers
Set posts_per_page
PHP
1 vote120 views1 answer
Php array merge skip diplicate
PHP
2 votes112 views1 answer
Undefined type 'App\Http\Controllers\api\DB'.
PHP
0 vote166 views1 answer
Unlink is a directory laravel
PHP Laravel
1 vote98 views1 answer
Laravel storage check file exists
PHP
1 vote144 views1 answer
Wordpress display post comment number
PHP Wordpress
0 vote105 views1 answer
Return last inserted id mysql opencart
PHP
0 vote124 views1 answer
Codeigniter crud generator
PHP CodeIgniter
2 votes145 views1 answer
Laravel 8 delete by id
PHP Laravel
16 votes100 views6 answers
Laravel run migration
PHP