/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

10 votes212 views1 answer
Php convert array to json object
PHP
0 vote237 views1 answer
How to merge 2 laravel eloquent records
PHP Laravel
1 vote228 views1 answer
Phpmyadmin delete all tables
PHP
0 vote227 views1 answer
Php get text from html
PHP
8 votes233 views4 answers
Laravel get all session data
PHP
0 vote243 views1 answer
Unset _post
PHP
46 votes235 views6 answers
Clear laravel cache
PHP
4 votes239 views4 answers
Php pretty print
PHP
1 vote226 views1 answer
How delete the table in laravel in the commend
PHP Laravel
3 votes229 views4 answers
Delete multiple row by model in laravel
PHP Laravel