/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

38 votes288 views6 answers
Laravel foreign key constraint
PHP
1 vote375 views1 answer
Add 2 hours to current time in cakephp
PHP CakePHP
0 vote401 views1 answer
Symfony send exception
PHP Symfony
0 vote320 views1 answer
No captcha laravel
PHP Laravel
3 votes335 views1 answer
Convert base64 string to pdf in php
PHP
0 vote337 views1 answer
Laravel create table with model command line
PHP Laravel
0 vote246 views1 answer
How to remove Website field from comments
PHP
-1 vote277 views2 answers
West african timezone in php
PHP
0 vote340 views1 answer
Laravel skip a loop if error
PHP Laravel
0 vote363 views1 answer
[InvalidArgumentException] Could not find package symfony/web-server-bundle in a version matching 5.0.
PHP Symfony