- (Subtract) (SQL Server Compact)
Subtracts two numbers. This subtraction arithmetic operator can also subtract a number, in days, from a date.
The following example uses the subtraction arithmetic operator to get the number of days between the time a customer placed an order and when the order was shipped.
SELECT (DATEPART(day, ShippedDate) - DATEPART(day, OrderDate)) FROM Orders WHERE OrderID = '10248' --The value returned is '12'.