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 vote98 views1 answer
Initcap in sql
SQL
0 vote106 views1 answer
Sort by
SQL
0 vote104 views1 answer
Addition of 2 column value in mysql
SQL
2 votes100 views1 answer
Drop sequence
SQL
2 votes113 views2 answers
How to run postgresql in linux
SQL
0 vote97 views1 answer
Postgresql isnull with max
SQL
0 vote105 views1 answer
Check index sql server
SQL
2 votes115 views3 answers
Postgres json to string
SQL
0 vote133 views1 answer
Mysql where sum > 0
SQL
0 vote108 views1 answer
Mysql multiple primary keys
SQL