/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

4 votes160 views4 answers
Laravel check if table has column
PHP Laravel
0 vote143 views1 answer
Laravel carbon subtract minutes to current time
PHP Laravel
0 vote180 views1 answer
Comment installer laravel avec docker
PHP Laravel
4 votes172 views1 answer
Password match laravel
PHP Laravel
7 votes193 views1 answer
Laravel db seed specific class
PHP Laravel
7 votes175 views6 answers
Laravel get url path
PHP Laravel
0 vote166 views1 answer
Copy file from one directory to another Laravel
PHP Laravel
0 vote149 views1 answer
Markdown mail html rendering laravel
PHP Laravel
15 votes153 views3 answers
Pass data to blade laravel
PHP Laravel
0 vote158 views1 answer
Was loaded over https, but requested an insecure xmlhttprequest endpoint laravel
PHP Laravel