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

1 vote243 views1 answer
Get create table query existing table mysql
SQL
14 votes309 views1 answer
How to export db from mysql
SQL
1 vote242 views1 answer
T-sql disable system versioning
SQL
0 vote217 views1 answer
Lister les index d'une table oracle
SQL
1 vote225 views1 answer
Show table status command in mysql
SQL
5 votes253 views3 answers
Sql server utc to local
SQL
1 vote251 views1 answer
SQl Server Versionen Releases und Build-Nummern
SQL
0 vote242 views1 answer
Can we rollback data that are deleted using DELETE clause?
SQL
10 votes248 views2 answers
Oracle alter sequence nextval
SQL
19 votes239 views5 answers
Change column name mysql command line
SQL