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

2 votes309 views2 answers
Mysql search for column name in all tables
SQL
2 votes309 views1 answer
Can you use a where clause for a child query
SQL
-1 vote276 views1 answer
Raise ImproperlyConfigured('mysqlclient 1.3.13 or newer is required; you have %s.' % Database.__version__) django.core.exceptions.ImproperlyConfigured: mysqlclient 1.3.13 or newer is required; you have 0.9.3.
SQL
4 votes288 views2 answers
Host '192.168.43.100' is not allowed to connect to this MySQL server
SQL
0 vote292 views1 answer
Select count postgres double row count > 1
SQL
1 vote302 views1 answer
Mysql event last execution
SQL
0 vote490 views1 answer
The differnece between to values in sql
SQL
2 votes320 views1 answer
Coalesce sql
SQL
1 vote498 views2 answers
Sql unique rows
SQL
14 votes305 views3 answers
Delete all records from table except sql
SQL