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 vote374 views1 answer
How do I insert a blob in SQL?
SQL
5 votes328 views1 answer
How to check nls timestamp format in oracle
SQL
0 vote369 views1 answer
SQL column name Oracle
SQL
-2 votes362 views2 answers
Union vs union all in sql
SQL
0 vote350 views1 answer
Dump db only triggers mysql
SQL
2 votes351 views4 answers
Duplicate record mysql
SQL
-2 votes365 views1 answer
No module named '_sqlite3
SQL
0 vote350 views1 answer
Use between operator in mysql
SQL
0 vote353 views1 answer
Sql recherche nom prenom
SQL
0 vote356 views1 answer
Sqlite to csv statement
SQL