Age postgres

#Code language: SQL (Structured Query Language) (sql)
SELECT age(CAST (day_of_birth AS timestamp)) AS Age;
--0 years 0 months 0 days
SELECT (CURRENT_DATE - CAST(day_of_birth AS date))/365 age;
--0 (age_in_years)

Source: postgresqltutorial.com

Similar codes

0 vote274 views1 answer
Finding leap year in sql
SQL
1 vote239 views2 answers
T sql get foreign key
SQL
0 vote294 views1 answer
Postgres extract number from string
SQL
10 votes232 views5 answers
Between keyword in sql
SQL
0 vote228 views1 answer
Mysql delete from where like
SQL
8 votes227 views1 answer
Oracle find text in functions
SQL
0 vote262 views1 answer
Tsql find the value and count of the item that occurs the most in a column
SQL
0 vote195 views1 answer
How to see the content of tables in pgadmin
SQL
1 vote249 views1 answer
Sql view where tables have same column name combine results
SQL
0 vote197 views1 answer
Oracle list all stored procedures
SQL