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

7 votes130 views3 answers
SQL create a new table
SQL
5 votes172 views3 answers
Create function in postgresql
SQL
1 vote171 views1 answer
Oracle previous year
SQL
0 vote134 views1 answer
Find all tables where column name exists oracle
SQL
0 vote130 views1 answer
Sql query interview questions githu
SQL
1 vote129 views4 answers
Get week day from date in sql
SQL
0 vote132 views1 answer
Google sheets filter rows above current cell
SQL
0 vote142 views1 answer
Mysql group by derived column
SQL
0 vote129 views1 answer
Wordpress database query change url
SQL
6 votes158 views2 answers
Clear a table in mysql
SQL