/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

0 vote160 views1 answer
ERROR: The following modules depend on mpm_prefork and need to be disabled first: php7.2
PHP
0 vote193 views4 answers
Laravel collection contains
PHP
0 vote213 views1 answer
Group where conditions in laravel
PHP Laravel
2 votes172 views1 answer
Get the current route in laravel
PHP Laravel
-2 votes177 views2 answers
How to fetch data using pdo in php
PHP
7 votes189 views6 answers
Laravel validation unique email
PHP Laravel
0 vote163 views1 answer
Php mysql foreach is bad pardics ?
PHP
0 vote227 views1 answer
Php adding options from an array
PHP
2 votes174 views1 answer
Laravel string key
PHP Laravel
1 vote158 views1 answer
Php déclarer une constante URL
PHP