Search
 
SCRIPT & CODE EXAMPLE
 

SQL

SQL DATEDIFF(date_part, start_date, end_date)

SELECT DATEDIFF(month, '2020-12-31 23:59:59', '2022-01-01 00:00:00');
-- outputs: 13
Comment

PREVIOUS NEXT
Code Example
Sql :: check ksql db health 
Sql :: select year from dual oracle 
Sql :: what is truncate in sql 
Sql :: how to check common records in 2 table 
Sql :: compare field sql server 
Sql :: oracle cast boolean to varchar2 
Sql :: insert using condition postgres 
Sql :: sql server obtener nombre sin espacios en blanco 
Sql :: mssql coalesce 
Sql :: show sql property syntax for jpa. 
Sql :: npm ERR! code ELIFECYCLE npm ERR! errno 1 npm ERR! sqlite3@4.2.0 install: `node-pre-gyp install --fallback-to-build` npm ERR! Exit status 1 npm ERR! npm ERR! Failed at the sqlite3@4.2.0 install script. 
Sql :: oracle diskgroup 
Sql :: mysql average from two table 
Sql :: mssql unique key accept nulls 
Sql :: greater than or equal to symbol in postgres 
Sql :: SQL COMO ALTERA NOME DE TABELA 
Sql :: sqlalchemy existing db file 
Sql :: how to declare variable date in mysql 
Sql :: postgresql create table add unique constraints 
Sql :: cross join sl 
Sql :: insert into table sql 
Sql :: Can you Join two Tables With Common Column? 
Sql :: mysql copy data from one table to another 
Sql :: inserting values in sql 
Sql :: mysql large import 
Sql :: sql injection 
Sql :: join with multiple conditions sql 
Sql :: sql stored procedure output parameters 
Sql :: group by sql 
Sql :: select sql 
ADD CONTENT
Topic
Content
Source link
Name
2+9 =