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 vote148 views1 answer
Use of undefined constant mysql_assoc - assumed
SQL
0 vote152 views4 answers
What is unique key in sql
SQL
0 vote131 views1 answer
Lost connection to MySQL server during query when dumping table
SQL
2 votes144 views1 answer
Get hour from date sql
SQL
0 vote141 views1 answer
Mysql where in keep order
SQL
0 vote224 views1 answer
Install ms sql server management studio
SQL
2 votes187 views1 answer
Oracle Column Names of a table
SQL
0 vote158 views1 answer
Codigo crear tablas sql server
SQL
0 vote142 views1 answer
Datagrip go to line
SQL
0 vote141 views1 answer
Sql server select top 2 of each group
SQL