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

3 votes331 views1 answer
Oracle list invalid password ORA-01017
SQL
6 votes318 views1 answer
To count number of rows in SQL table
SQL
7 votes346 views1 answer
Sql disable safe mode
SQL
2 votes351 views2 answers
Get all tables using like
SQL
3 votes400 views1 answer
Oracle list invalid password logon denied
SQL
0 vote332 views1 answer
Access mysql database docker container shell
SQL
0 vote328 views1 answer
R rmysql connect local database Plugin caching_sha2_password could not be loaded
SQL
9 votes331 views6 answers
Sql add column with default value
SQL
0 vote344 views4 answers
First max salary in sql
SQL
3 votes318 views2 answers
Pl sql escape '
SQL