Sql

Search

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)

Comment

PREVIOUS	NEXT

Code Example
Sql :: laravel to sql
Sql :: insert postgres
Sql :: hibernate with springboot mysql
Sql :: sql server alter table add column datetime default current_timestamp
Sql :: DUPLICATE column values
Sql :: apex select list ORA-20999
Sql :: mysql show carset
Sql :: sql server pagination
Sql :: sql delete records older than 1 day
Sql :: mqtt Error: Address not available
Sql :: mssql get running queries
Sql :: sql primary key with multiple columns
Sql :: mysql show tables in database
Sql :: alter table drop column
Sql :: how to change owner in postgres
Sql :: add days in oracle sql
Sql :: différence entre deux dates sql oracle
Sql :: if then else sqlite
Sql :: sqlite version check
Sql :: how to drop a trigger in postgresql
Sql :: script to add new column in table sql
Sql :: how to add default constraint in mysql
Sql :: how to create an empty table from an existing table
Sql :: add new column not null sql server
Sql :: python escape string for sql
Sql :: get all db sizes in mysql server
Sql :: oracle last day of month
Sql :: mysql remote connection command line
Sql :: sql delete join
Sql :: sql decimal to 2 places

Search

SQL

age postgres

ADD CONTENT