/PHP/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 votes284 views2 answers
Laravel update from query
PHP
0 vote301 views1 answer
Laravel automatically generate unique username
PHP Laravel
0 vote311 views1 answer
Learndash edit profile link
PHP
0 vote269 views1 answer
Message"Class 'Input' not found"
PHP
0 vote332 views1 answer
Wordpress pagination custom arrow
PHP Wordpress
0 vote255 views1 answer
Financial year calculation in php
PHP
0 vote261 views1 answer
Php forbidden header
PHP
2 votes276 views5 answers
Laravel drop table migration
PHP Laravel
0 vote267 views1 answer
Double where condition in laravel
PHP
57 votes277 views6 answers
In array php
PHP