Calculate age in sql

#THIS IS FOR POSTGRES
# 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

3 votes112 views2 answers
Mysql sum with condition
SQL
0 vote217 views1 answer
Sql server rtrim everything after character
SQL
3 votes161 views1 answer
Oracle user quota unlimited
SQL
16 votes211 views3 answers
Order by sql query
SQL
0 vote205 views1 answer
Postgresql conectar
SQL
0 vote210 views1 answer
Mysql select row with min date
SQL
0 vote179 views1 answer
Sql requete number pair
SQL
0 vote211 views1 answer
Change mysql version to 5.7 in ubuntu
SQL
0 vote179 views1 answer
Mysql regex exact match
SQL
2 votes166 views1 answer
Cast string to datetime mysql
SQL