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 vote354 views1 answer
Write a query to peint the pattern P(20)
SQL
2 votes342 views1 answer
Set boolean flasksql
SQL
0 vote349 views1 answer
Running query in redshift
SQL
1 vote298 views2 answers
OSError: mysql_config not found mysql_config --version mariadb_config --version mysql_config --libs ---------------------------------------- ERROR: Command errored out with exit status 1: python setup.py egg_info Check the logs for full command outpu
SQL
4 votes358 views4 answers
Start mysql
SQL
3 votes356 views1 answer
Postgresql db owner change
SQL
0 vote352 views1 answer
Sql #region
SQL
2 votes349 views1 answer
Oracle apex list connected users
SQL
2 votes373 views3 answers
Sql function
SQL
0 vote357 views1 answer
T-SQL Create Trigger
SQL