/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

3 votes228 views2 answers
How to use required_with in laravel to array element
PHP Laravel
0 vote180 views1 answer
Laravel request file empty
PHP
2 votes207 views2 answers
Check if date between two dates laravel eloquent
PHP Laravel
0 vote361 views1 answer
How to check if a url has a certain word in laravel
PHP
1 vote211 views2 answers
Update checkbox value in laravel
PHP Laravel
1 vote364 views1 answer
How to stop laravel server
PHP Laravel
0 vote170 views1 answer
Pass the product name to form field cf7 woocommerce
PHP
0 vote177 views1 answer
Laravel 8 - get values of url query strings in controller
PHP
0 vote195 views1 answer
Access config variable in codeigniter controller
PHP
0 vote242 views1 answer
Main.php
PHP