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 vote231 views1 answer
Doesn't have default value mysql
SQL
0 vote229 views2 answers
How to prevent sql injection in java
SQL
0 vote233 views1 answer
Drop-toys-table
SQL
1 vote210 views1 answer
Sql server reseed single table
SQL
0 vote235 views1 answer
Mysqli_connect using prepare statement
SQL
0 vote213 views1 answer
How to print records of employees hired in particular month in oracle
SQL
6 votes206 views3 answers
Mysql first day of year
SQL
0 vote225 views1 answer
How to get table current identity value in sql server
SQL
0 vote208 views1 answer
Search db for table name
SQL
1 vote248 views2 answers
Postgres select from last 3 months
SQL