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 vote352 views1 answer
Kotlin sqlite delete row
SQL
1 vote377 views1 answer
Postgresql define pk sequence next number
SQL
0 vote364 views1 answer
Get enginge db mysql
SQL
0 vote392 views1 answer
Is not numeric sql
SQL
1 vote373 views1 answer
SQL query to get all table records count from a database
SQL
0 vote374 views1 answer
A good way of running a SQL query in JDBC using a parameterized statement
SQL
0 vote373 views1 answer
Sql select all records from all tables where not empty
SQL
3 votes365 views1 answer
Oracle apex call duration
SQL
0 vote345 views1 answer
Access denied for user 'root'@'localhost' workbench ubuntu
SQL
2 votes383 views2 answers
Postgresql search all tables for column name
SQL