Calculate age in sql postgresql

#THIS WORKS FOR POSTGRES and MYSQL
# You can use the AGE function. The AGE function requires two arguementS.
# AGE(late date, early date). The NOW() function returns the current timestamp.

AGE(NOW(), date_of_birth) AS age

#Since NOW() is a timestamp, the result will be like this:
# 45 years 2 months 15 days 21:43:05.378372
#You can then use this to extract the age.

LEFT(age, STRPOS(age,' '))

Similar codes

0 vote171 views1 answer
Min mysql
SQL
3 votes182 views2 answers
Tsql join multiple record in one string
SQL
3 votes198 views1 answer
Define REGEXP?
SQL
0 vote172 views1 answer
Mysqldump ignore table
SQL
2 votes191 views2 answers
Mysql on duplicate key update get value from values
SQL
2 votes174 views6 answers
In in sql
SQL
0 vote165 views1 answer
Object Information
SQL
1 vote186 views2 answers
Mysql error 1215
SQL
0 vote181 views1 answer
Psql show db
SQL
-1 vote164 views1 answer
Add column alter table default value
SQL