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 vote142 views1 answer
How to get table id sequence postgres
SQL
1 vote110 views1 answer
Show all event schedular on mysql
SQL
6 votes124 views2 answers
Sql sequence
SQL
0 vote109 views1 answer
Nvl2 syntax
SQL
4 votes109 views4 answers
Oracle tablespace tables list
SQL
-1 vote121 views3 answers
Error: mysql shutdown unexpectedly.
SQL
0 vote94 views1 answer
Call procedure in wordpress
SQL
9 votes116 views2 answers
Mac mysql this is incompatible with sql_mode=only_full_group_by
SQL
23 votes115 views4 answers
How to uninstall postgresql in ubuntu
SQL
0 vote62 views1 answer
Calculate discount from original price sql
SQL