/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 vote142 views1 answer
Create resources laravel
PHP Laravel
1 vote275 views5 answers
Laravel eloquent batch insert
PHP Laravel
2 votes186 views6 answers
Laravel get query parameters
PHP Laravel
26 votes303 views6 answers
Laravel make model with migration and controller
PHP Laravel
0 vote193 views1 answer
Laravel select option form add please select option
PHP Laravel
10 votes282 views4 answers
Compact laravel
PHP Laravel
0 vote238 views1 answer
Laravel app running in console
PHP Laravel
22 votes201 views5 answers
Get logged user id laravel
PHP Laravel
8 votes198 views2 answers
Laravel Edit
PHP Laravel
0 vote225 views1 answer
Laravel eloquent where value less then 5 and greter then 0
PHP Laravel