/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

12 votes211 views2 answers
Laravel query with trashed
PHP Laravel
2 votes179 views1 answer
How to run multiple laravel projects at same time
PHP Laravel
7 votes168 views4 answers
Laravel chunk
PHP Laravel
5 votes171 views3 answers
Laravel get parameters from request
PHP Laravel
0 vote175 views1 answer
How to collapse array in laravel
PHP Laravel
28 votes182 views12 answers
Laravel middleware
PHP Laravel
8 votes185 views4 answers
Laravel model soft delete
PHP Laravel
0 vote178 views1 answer
Laravel collection partition
PHP Laravel
0 vote190 views1 answer
Custom pagination laravel css
PHP Laravel
0 vote179 views1 answer
Migration not found laravel
PHP Laravel