/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

1 vote217 views1 answer
Laravel change post request before save
PHP Laravel
12 votes208 views6 answers
Laravel relationship
PHP Laravel
0 vote212 views1 answer
Check if column has value in laravel eloquent
PHP Laravel
1 vote276 views3 answers
Laravel convert timestamp to date
PHP Laravel
0 vote225 views2 answers
Laravel pagination layout issue
PHP Laravel
8 votes205 views1 answer
Laravel link storage to public
PHP Laravel
0 vote220 views1 answer
Morph relation laravel
PHP Laravel
3 votes222 views1 answer
Laravel e commerce full project
PHP Laravel
0 vote223 views1 answer
Route pattern cannot reference variable name more than once. laravel
PHP Laravel
1 vote214 views1 answer
Laravel read origanl value before update
PHP Laravel