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 vote122 views1 answer
MySQL FIND_IN_SET()
SQL
0 vote122 views1 answer
Materialized view redshift
SQL
1 vote101 views1 answer
How to get mysql db size
SQL
1 vote114 views1 answer
Sql server: query to find out all the places where the table is used
SQL
0 vote119 views1 answer
Sql select by content lenght
SQL
0 vote117 views1 answer
Python connect microsoft sql server
SQL
0 vote122 views1 answer
Create a sql server database programmatically
SQL
1 vote116 views1 answer
Show table status command in mysql
SQL
2 votes125 views1 answer
Oracle generated column
SQL
1 vote80 views1 answer
Postgresql last element of array
SQL