/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

1 vote433 views2 answers
Laravel check if email is real
PHP Laravel
1 vote347 views2 answers
Laravel log to console
PHP Laravel
0 vote342 views1 answer
Compile custom/plain css with mix in laravel
PHP Laravel
3 votes354 views6 answers
Last insert id in laravel
PHP Laravel
6 votes394 views2 answers
Laravel 6 get user id
PHP Laravel
2 votes393 views6 answers
Composer create project laravel 7
PHP Laravel
2 votes379 views1 answer
Laravel 8 delete by id
PHP Laravel
0 vote354 views1 answer
Refresh web route laravel
PHP Laravel
0 vote408 views1 answer
Push to aws instance ssh without using laravel
PHP Laravel
8 votes333 views3 answers
Laravel check record exists
PHP Laravel