/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 vote147 views2 answers
Laravel use global variable in model
PHP Laravel
2 votes175 views1 answer
Laravel how to test email testing
PHP Laravel
0 vote143 views1 answer
Check laravel first null
PHP Laravel
2 votes149 views1 answer
Laravel-ckeditor
PHP Laravel
1 vote130 views1 answer
Get original name without mutant model laravel
PHP Laravel
2 votes141 views1 answer
Laravel 8 previous page
PHP Laravel
0 vote193 views1 answer
Laravel vu3
PHP Laravel
0 vote145 views1 answer
Laravel unknown column updated at
PHP Laravel
4 votes135 views3 answers
Laravel check environment hlper
PHP Laravel
1 vote148 views2 answers
Table has column laravel
PHP Laravel