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 votes217 views3 answers
Mysql kill
SQL
0 vote168 views1 answer
Oracle NLS_CHARACTERSET
SQL
4 votes163 views1 answer
Mysql timestamp in laravel migration
SQL
0 vote187 views1 answer
Sql query wordpress export post
SQL
0 vote162 views1 answer
Mysql jdbc timezone
SQL
0 vote168 views1 answer
Java sql connection
SQL
1 vote159 views1 answer
How to run sql script
SQL
0 vote194 views1 answer
User, group, or role 'open' already exists in the current database.
SQL
0 vote147 views0 answer
SQL
9 votes172 views4 answers
How to create new user and database postgresql in ubuntu
SQL