/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 votes114 views5 answers
Laravel run single migration
PHP Laravel
0 vote114 views1 answer
Laravel str library
PHP Laravel
0 vote93 views1 answer
Laravel custom abort message
PHP
0 vote112 views1 answer
PHP Create Swiss QR-Bill API
PHP
0 vote100 views1 answer
How to start the index from 1 in php?
PHP
0 vote87 views1 answer
Compact example in php
PHP
0 vote110 views1 answer
Laravel route name with parameters
PHP Laravel
0 vote97 views1 answer
Get min value from array php
PHP
0 vote108 views1 answer
Install Older Version of Laravel using Composer
PHP
0 vote95 views1 answer
Update button
PHP