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

0 vote187 views1 answer
Psql list rules
SQL
3 votes183 views1 answer
Sql is not like
SQL
11 votes191 views1 answer
Sql insert multiple rows from select
SQL
0 vote208 views2 answers
SQLSTATE[HY000]: General error: 3780 Referencing column 'role_id' and referenced column 'id' in foreign key constraint 'user_role_id foreign' are incompatible.
SQL
11 votes159 views2 answers
Having clause
SQL
0 vote172 views3 answers
Insert or ignore postgres
SQL
0 vote177 views1 answer
Postgres week number
SQL
0 vote187 views1 answer
Como hacer una consulta de un registro que no esta en una tabla en mysql
SQL
7 votes197 views2 answers
Where keyword sql
SQL
13 votes176 views4 answers
Mysql get last row
SQL