/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

39 votes196 views6 answers
Laravel foreign key constraint
PHP Laravel
0 vote190 views2 answers
Adminlte con laravel 8
PHP Laravel
15 votes208 views3 answers
Foreign id laravel migration
PHP Laravel
0 vote274 views1 answer
Laravel custom abort message
PHP Laravel
0 vote209 views1 answer
How do i implement blockchain payments on laravel website
PHP Laravel
1 vote184 views1 answer
Laravel descending order paginate eloquent
PHP Laravel
0 vote226 views2 answers
Laravel set middleware default
PHP Laravel
1 vote188 views1 answer
Laravel server sent events
PHP Laravel
23 votes174 views6 answers
Laravel logs
PHP Laravel
2 votes193 views3 answers
Laravel model particular column
PHP Laravel