postgresql calculate age from birthdate

The solution for this is noted below

postgresql calculate age from birthdate

Solution

SELECT EXTRACT(YEAR from AGE(NOW(), birth)) as "age", * FROM customers;

Try other methods by searching on the site. That is if this doesn’t work