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

12 votes201 views6 answers
Change mysql root password
SQL
0 vote134 views1 answer
Store query result in variable sql
SQL
-1 vote180 views1 answer
Get id from just inserted row mysql server python
SQL
4 votes168 views1 answer
Change nls_date_format
SQL
0 vote166 views1 answer
An exception occurred while executing a transact-sql statement or batch user,group or role already
SQL
1 vote126 views1 answer
File /etc/init.d/mysql not exists
SQL
1 vote184 views2 answers
Foreign key set 0
SQL
7 votes181 views1 answer
Query postgres delete duplicates
SQL
0 vote164 views1 answer
Npm ERR! code ELIFECYCLE npm ERR! errno 1 npm ERR! [email protected] install: `node-pre-gyp install --fallback-to-build` npm ERR! Exit status 1 npm ERR! npm ERR! Failed at the [email protected] install script.
SQL
1 vote171 views1 answer
Python escape mysql
SQL