/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

-1 vote271 views2 answers
Adminlte 3 laravel
PHP
1 vote292 views1 answer
Cakephp 4 change layout view in a method
PHP
0 vote255 views1 answer
How to clear post array on referesh + not refill when return
PHP
0 vote347 views1 answer
How to prevent user to add duplicate card in stripe using laravel
PHP
0 vote247 views1 answer
Magento 1.9 print blank page error
PHP
0 vote339 views1 answer
Laravel nova card duplicate keys
PHP Laravel
0 vote260 views1 answer
How to read laravel query string with dash
PHP
0 vote317 views1 answer
Show float laravel blade
PHP Laravel
0 vote282 views1 answer
Php return a header 200
PHP
0 vote332 views1 answer
Action after model is created laravel
PHP