Export (0) Print
Expand All
Expand Minimize
8 out of 16 rated this helpful - Rate this topic

DATEDIFF (SQL Server Compact Edition)

Returns the number of date and time boundaries crossed between two specified dates.


DATEDIFF ( datepart , startdate , enddate ) 
datepart

The parameter that specifies on which part of the date to calculate the difference. For more information, see the "Remarks" section later in this topic.

startdate

The beginning date for the calculation. The startdate argument is an expression that returns a datetime value or a Unicode character string in a date format.

If you specify only the last two digits of the year, values less than or equal to the last two digits of the value of the two digit year cutoff configuration option are in the same century as the cutoff year. Values greater than the last two digits of the value of this option are in the century that precedes the cutoff year. For example, if the two digit year cutoff is 2049 (the default value), the '49' is interpreted as 2049 and '50' is interpreted as 1950. To avoid ambiguity, use four-digit years.

For more information about specifying dates, see datetime in Data Types.

enddate

The ending date for the calculation. The enddate argument is an expression that returns a datetime value or a Unicode character string in a date format.

The following table lists the datepart options and abbreviations recognized by Microsoft SQL Server 2005 Compact Edition.

Datepart Abbreviations

year

yy, yyyy

quarter

qq, q

month

mm, m

dayofyear

dy, y

day

dd, d

week

wk, ww

weekday

dw

hour

hh

minute

mi, n

second

ss, s

millisecond

ms

The following example determines the number of days it took to ship the orders made by a company that has a CustomerID of 'VINET'.

SELECT OrderID, DATEDIFF (d, OrderDate, ShippedDate) AS "Shipping Time in Days" FROM Orders WHERE CustomerID = 'VINET'

This is the result set:

OrderID         Shipping Time in Days
-------------------------------------
10295           8
10737           7
10274           10
10248           12
10739           5
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.