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 vote311 views1 answer
SQL COMO ALTERA NOME DE TABELA
SQL
1 vote290 views1 answer
Import local sql into remote mysql
SQL
1 vote317 views1 answer
Alter add syntax
SQL
0 vote296 views1 answer
Oracle sql generate list of days
SQL
0 vote311 views1 answer
Set default value now() date
SQL
5 votes305 views1 answer
Oracle create table comment
SQL
0 vote276 views1 answer
Create dabase postgresql
SQL
4 votes320 views2 answers
Truncate oracle
SQL
2 votes310 views1 answer
How to create sql database
SQL
24 votes293 views4 answers
Mssql get all table names
SQL