Search
 
SCRIPT & CODE EXAMPLE
 

SQL

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 
ADD CONTENT
Topic
Content
Source link
Name
3+6 =