日期和时间函数:
DECLARE @VARDATE DATETIME
SET @VARDATE = GETDATE()
SELECT @VARDATE AS GETDATE
SELECT DATEADD(DAY,15,@VARDATE) AS DATEADD
SELECT DAY(@VARDATE) AS DAY
SELECT MONTH(@VARDATE) AS MONTH
SELECT YEAR(@VARDATE) AS YEAR
SELECT DATEDIFF(day,'2014-04-29','2014-5-15') AS DiffDate
SELECT GETUTCDATE() AS GETUTCDATE
还有 DATEPART 函数和DATENAME函数。。。