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

0 vote187 views1 answer
Rollback to name in sql
SQL
0 vote146 views1 answer
Mysql timeout 30 seconds
SQL
0 vote182 views1 answer
Postgresql not in alternative
SQL
1 vote188 views3 answers
Epoch to datetime
SQL
6 votes168 views1 answer
Oracle trigger after logon on database
SQL
0 vote202 views1 answer
Mysql dump with table query
SQL
15 votes236 views6 answers
Drop foreign key mysql
SQL
0 vote189 views1 answer
Mariadb maximum left join
SQL
4 votes177 views1 answer
Sql delete where in select
SQL
0 vote194 views1 answer
#1231 - Variable 'sql_mode' can't be set to the value of 'NULL'
SQL