/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 vote136 views1 answer
Laravel new line in session flash message
PHP Laravel
22 votes169 views5 answers
Foreign key string laravel
PHP Laravel
4 votes138 views5 answers
Laravel storage
PHP Laravel
0 vote129 views1 answer
Laravel take value from different array by key
PHP Laravel
45 votes179 views6 answers
Laravel migration add column after
PHP Laravel
5 votes157 views2 answers
How to get the index in foreach loop in laravel
PHP Laravel
0 vote137 views1 answer
My laravel has no docker-composer.yml file
PHP Laravel
0 vote128 views1 answer
Laravel faker generate country code
PHP Laravel
1 vote129 views1 answer
Foreign key nullable in laravel
PHP Laravel
1 vote132 views1 answer
Class 'illuminate support facades input' not found laravel 7
PHP Laravel