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

0 vote160 views1 answer
Drop all procedures sql server
SQL
4 votes158 views1 answer
Create table if not exist in sqlite
SQL
10 votes155 views1 answer
Query to find object dependencies in oracle
SQL
0 vote163 views1 answer
Spark sql grows beyond 64 kb
SQL
2 votes185 views1 answer
How to check grants on a package in oracle
SQL
13 votes160 views1 answer
Select count of distinct values sql
SQL
0 vote152 views1 answer
Phpmyadmin tabellentyp ändern
SQL
0 vote154 views2 answers
Mysql update two tables at once
SQL
25 votes178 views1 answer
How to update an attribute in MySQL
SQL
1 vote283 views2 answers
Postgres select from last 3 months
SQL