/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 votes141 views2 answers
Wordpress logout to home page
PHP
2 votes172 views3 answers
How to share a helper globally laravel
PHP Laravel
0 vote195 views1 answer
Laravel asset prevent browser caching
PHP Laravel
0 vote149 views1 answer
Adding field to array on condition laravel
PHP
0 vote225 views1 answer
Définir un nombre maximum de mots sur les titres des publications WordPress
PHP Wordpress
0 vote166 views1 answer
Wordpress register_post_type capability gutenberg
PHP Wordpress
2 votes159 views1 answer
Undefined variable _session
PHP
0 vote150 views2 answers
Laravel 8 query builder, Left Join / Right Join Clause
PHP Laravel
11 votes153 views4 answers
Php str starts with
PHP
0 vote158 views1 answer
Codeigniter abort 404
PHP