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

2 votes138 views1 answer
Foreign key example in dbms
SQL
0 vote184 views1 answer
Pgadmin see indexes
SQL
0 vote203 views1 answer
Add mysql database to power bi web
SQL
0 vote183 views1 answer
Postgres set default schema
SQL
8 votes211 views1 answer
Oracle current date plus 1 month
SQL
0 vote192 views1 answer
Prodection ready postgres database step by step
SQL
0 vote202 views1 answer
View psql output in horizontal scrolling
SQL
5 votes774 views1 answer
Oracle ora-00054 find
SQL
0 vote138 views1 answer
How to get last client id sql
SQL
4 votes205 views2 answers
Oracle unlock account
SQL