Search
 
SCRIPT & CODE EXAMPLE
 

SQL

DATEDIFF

DATEDIFF ( datepart , startdate , enddate ) 

-- example:
SELECT DATEDIFF(day, '2036-03-01', '2036-02-28');

-- Returns -2
Comment

PREVIOUS NEXT
Code Example
Sql :: insert current date sql 
Sql :: date format in postgresql 
Sql :: describe table postgres 
Sql :: Check user permissions on postgres database 
Sql :: update query in sql server 
Sql :: how to export only procedures mysql 
Sql :: sql server output parameter 
Sql :: n highest salary in sql 
Sql :: string to sql timestamp 
Sql :: sql server backup table 
Sql :: select where duplicate mysql 
Sql :: show table postgres command 
Sql :: mysql email validation 
Sql :: how to run mysql on terminal mac 
Sql :: sql current date 
Sql :: postgres : ERROR: division by zero 
Sql :: check lock on table in sql server 
Sql :: mysql get latest duplicate rows 
Sql :: sql #region 
Sql :: get foreign table names mysql 
Sql :: sql declare variable 
Sql :: run postgresql dump to csv 
Sql :: json query 
Sql :: sql substring 
Sql :: import sql dump into postgresql database 
Sql :: with postgres 
Sql :: insert into using contant values and source table columns with sql 
Sql :: mysqlclient error 
Sql :: check database sessions oracle 
Sql :: How do I insert a blob in SQL? 
ADD CONTENT
Topic
Content
Source link
Name
9+3 =