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

7 votes164 views4 answers
What is my mysql version
SQL
6 votes185 views6 answers
Code: 'ER_NOT_SUPPORTED_AUTH_MODE', errno: 1251, sqlMessage: 'Client does not support authentication protocol requested by server; consider upgrading MySQL client', sqlState: '08004', fatal: true
SQL
1 vote173 views1 answer
Cannot load driver class: com.mysql.cj.jdbc.Driver
SQL
2 votes182 views2 answers
Mysql add hours to time field
SQL
12 votes158 views4 answers
Mysql get date difference in hours
SQL
18 votes168 views6 answers
Create table mysql
SQL
0 vote158 views1 answer
Sql menampilkan data tabel
SQL
0 vote182 views1 answer
Uncheck constraints and delete from table
SQL
0 vote180 views1 answer
Disable database droping sql
SQL
1 vote159 views1 answer
Sql avg group by
SQL