SQL Server 2005 日期相关函数

select day(getdate())
select DATEADD(d,DATEDIFF(d,0,GETDATE()),0) --当天
select CAST(CONVERT(CHAR(8),GETDATE(),112) AS DATETIME) --当天
select CURRENT_TIMESTAMP--the ANSI form of GETDATE
select GETUTCDATE()--get(UTC)time
select DATENAME(weekday, '20060118 14:39:05.370')--星期三
select DATEDIFF(hour,getdate(),dateadd(day,1,getdate()))--24
select DATEDIFF(year, '20061231 23:59:59.997', '20070101 00:00:00.000')--1
select DATEPART(day, '20060118 14:39:05.370')--18