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

2 votes144 views2 answers
Mysql get last character of string
SQL
1 vote217 views1 answer
Sql and
SQL
0 vote199 views1 answer
Mariadb mysql root access denied
SQL
11 votes203 views4 answers
Update row in mysql
SQL
0 vote233 views1 answer
Composit key in sql
SQL
2 votes259 views1 answer
Oracle block
SQL
0 vote192 views1 answer
ORA-13717
SQL
7 votes200 views5 answers
Oracle alter table
SQL
0 vote212 views1 answer
Top 3 salary in sql
SQL
0 vote211 views1 answer
How to to get time in sql
SQL