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

10 votes144 views1 answer
Oracle object dependencies
SQL
44 votes223 views6 answers
Rename command in sql
SQL
0 vote148 views1 answer
Mysql terminal run sql file
SQL
1 vote169 views3 answers
Sql procedure
SQL
1 vote138 views1 answer
Loading local data is disabled mysql
SQL
3 votes135 views2 answers
Find the median in sql
SQL
12 votes198 views2 answers
Update column data type postgres
SQL
8 votes141 views1 answer
Sql limit results returned
SQL
0 vote133 views1 answer
Update if else mysql
SQL
0 vote149 views1 answer
How to run mysql in git bash
SQL