/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

7 votes195 views2 answers
Last recode of DB using laravel
PHP Laravel
6 votes190 views2 answers
How many products can a laravel ecommerce handle
PHP Laravel
0 vote217 views1 answer
Add another column in a table in laravel
PHP Laravel
6 votes201 views4 answers
Enset laravel session
PHP Laravel
1 vote217 views1 answer
Laravel get class name
PHP Laravel
0 vote201 views1 answer
Laravel carbon first day of month
PHP Laravel
0 vote208 views1 answer
Laravel 8 Pagination Ui Problem
PHP Laravel
0 vote226 views1 answer
Check null if string laravel
PHP Laravel
-2 votes267 views2 answers
Why we use pusher in laravel
PHP Laravel
14 votes254 views6 answers
Laravel create model and migration
PHP Laravel