/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 vote306 views1 answer
Laravel excel set cell height
PHP Laravel
2 votes299 views2 answers
Laravel get file in public folder
PHP Laravel
0 vote282 views6 answers
Create global function laravel
PHP Laravel
51 votes367 views3 answers
Laravel version check
PHP Laravel
2 votes296 views1 answer
Add id to route name in laravel blade
PHP Laravel
0 vote301 views1 answer
Access-control-allow-origin php laravel
PHP Laravel
0 vote281 views2 answers
Login with email and phone laravel
PHP Laravel
0 vote308 views2 answers
Laravel blade components
PHP Laravel
1 vote322 views3 answers
Import faker in laravel
PHP Laravel
4 votes241 views1 answer
Laravel schedule command every 8 hours laravel
PHP Laravel