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 vote221 views1 answer
Mysql milliseconds
SQL
2 votes214 views2 answers
Mysql find max value row
SQL
1 vote217 views2 answers
Procedure syntax
SQL
3 votes211 views2 answers
Oracle privileges users
SQL
0 vote202 views1 answer
Call rest api from postgresql
SQL
7 votes209 views4 answers
What is my mysql version
SQL
1 vote154 views1 answer
How to run sql script
SQL
0 vote210 views1 answer
How to drop a trigger in postgresql
SQL
0 vote199 views1 answer
Can we rollback deleted data in sql
SQL
2 votes204 views1 answer
Enum in SQL Server
SQL