以下示例确定在
AdventureWorks
数据库中产品的订单日期和当前日期相差的天数。USE AdventureWorks; GO SELECT DATEDIFF(day, OrderDate, GETDATE()) AS NumberOfDays FROM Sales.SalesOrderHeader; GO