/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

-2 votes158 views1 answer
Laravel if else condition in query
PHP Laravel
4 votes350 views6 answers
Laravel jwt
PHP Laravel
3 votes144 views1 answer
Date time laravel
PHP Laravel
0 vote145 views2 answers
How to rollback if one table in laravel didn't save data successfully
PHP Laravel
0 vote141 views3 answers
Run queue after x minutes laravel
PHP Laravel
0 vote141 views2 answers
Laravel model column default value
PHP Laravel
0 vote211 views1 answer
Manual collection laravel
PHP Laravel
6 votes187 views3 answers
Laravel ide-helper
PHP Laravel
0 vote138 views1 answer
Laravel collection last
PHP Laravel
0 vote148 views1 answer
Laravel new line in session flash message
PHP Laravel