/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

13 votes307 views6 answers
Laravel manually authenticate user
PHP
1 vote358 views2 answers
Insert data using mysqli in php
PHP
7 votes434 views3 answers
Generate shortcode wordpress plugin
PHP Wordpress
6 votes356 views2 answers
Disable laravel debugbar
PHP Laravel
1 vote380 views1 answer
Laravel clone row
PHP Laravel
0 vote318 views1 answer
How to set no cache header php
PHP
0 vote358 views1 answer
Controller class does not exist laravel
PHP Laravel
28 votes328 views6 answers
Laravel change column type
PHP
-2 votes303 views1 answer
Filter value in array php return single value
PHP
3 votes371 views1 answer
How validate array in laravel in request
PHP Laravel