/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 vote108 views1 answer
Launch new tab and refresh original page codeigniter
PHP CodeIgniter
1 vote125 views2 answers
Re migrate laravel
PHP
0 vote120 views1 answer
Share wordpress post on whatsapp without plugin
PHP
1 vote172 views1 answer
Wordpress get text of wordpress post
PHP Wordpress
37 votes123 views4 answers
Get PHP String Length
PHP
0 vote137 views1 answer
Php undefined function split
PHP
1 vote114 views1 answer
Laravel hasone users relations
PHP
3 votes127 views2 answers
Get details of user using token in laravel passport
PHP Laravel
-1 vote117 views3 answers
Laravel except route
PHP
105 votes293 views6 answers
Php strpos
PHP