Calculate age in sql postgresql

#THIS WORKS FOR POSTGRES and MYSQL
# 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 vote261 views1 answer
Update if else mysql
SQL
0 vote275 views1 answer
Mysql aspas simples
SQL
2 votes295 views1 answer
Coalesce sql
SQL
7 votes268 views1 answer
Sql disable safe mode
SQL
2 votes281 views1 answer
Show max_allowed_packet mysql
SQL
0 vote301 views1 answer
Database schema for mcqs type exam in sql
SQL
0 vote303 views1 answer
Generate sql from specific migration ef core
SQL
0 vote291 views1 answer
Sql query wordpress export post
SQL
1 vote255 views1 answer
Oracle create program if no exists
SQL
23 votes281 views6 answers
Create table sql server
SQL