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 vote120 views1 answer
Count in sql and diff
SQL
0 vote61 views1 answer
Delete all rows from table sqlite
SQL
0 vote143 views1 answer
Error Code: 1267. Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '=' 0.000 sec
SQL
0 vote104 views1 answer
Sql pivot without aggregate
SQL
0 vote109 views1 answer
Bus source and destination equal to destination and source of another by sql query
SQL
1 vote118 views1 answer
Oracle check table lock
SQL
2 votes106 views4 answers
Mysql select into new table
SQL
0 vote111 views1 answer
Mysql date time string format python
SQL
5 votes97 views1 answer
How to check port number for postgresql
SQL
10 votes92 views1 answer
Oracle dependency
SQL