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

4 votes131 views1 answer
Fetch first 10 rows in oracle sql developer
SQL
0 vote134 views1 answer
Lesser than or equal to symbol in postgres
SQL
2 votes135 views1 answer
Change primary key sql
SQL
0 vote150 views1 answer
Convert polygon to text in mysql
SQL
1 vote193 views1 answer
Ora-06502: pl/sql: numeric or value error: character string buffer too small
SQL
0 vote132 views1 answer
Renommer table sql
SQL
0 vote145 views1 answer
Sqlite get date only
SQL
15 votes134 views4 answers
How to get all tables in sql
SQL
0 vote172 views1 answer
Stop and start mysql
SQL
0 vote128 views1 answer
Oracle index hint multiple tables example
SQL