DATEDIFF funtion in sql server


DATEDIFF function is the return difference between two date values based on datepart specified.
Syntax:
DATEDIFF (datepart , startdate , enddate)
The <Datepart> parameter specifies on which part of the date to return a new value.
Valid values are
YEAR or YY,
QUARTER or QQ or Q,
MONTH or MM or M,
DAYOFYEAR or DY or Y,
DAY or DD or D,
WEEK or WK or WW,
WEEKDAY or DW or W,
HOUR or HH,
MINUTE or MI or N,
SECOND or SS or S,
and MILLISECOND or ms.
<Number> use to increment or decrement of <datepart> for new date,
<DATE> parameter is an expression that returns a DATETIME or SMALLDATETIME value.


EXAMPLE

SELECT DATEDIFF(YY,'12/12/2012','12/12/2014')
SELECT DATEDIFF(MM,'12/12/2012','12/12/2014')
SELECT DATEDIFF(DD,'12/12/2012','12/12/2014')
SELECT DATEDIFF(HH,'12/12/2012','12/12/2014')
SELECT DATEDIFF(SS,'12/12/2012','12/12/2014')
SELECT DATEDIFF(MS,'12/10/2014','12/12/2014')

NOTE:  For a millisecond, the maximum difference between start date and end date is 24 days, 20 hours, 31 minutes and 23.647 seconds. For the second, the maximum difference is 68 years.

Related Posts

What is the Use of isNaN Function in JavaScript? A Comprehensive Explanation for Effective Input Validation

In the world of JavaScript, input validation is a critical aspect of ensuring that user-provided data is processed correctly. One indispensa...