1:DateName函数:
SELECT GETDATE() AS 当前日期,
DATENAME(YEAR, GETDATE()) AS 年,
DATENAME(MONTH, GETDATE()) AS 月,
DATENAME(DAY, GETDATE()) AS 日,
DATENAME(quarter, GETDATE()) AS 季度,
DATENAME(dayofyear, GETDATE()) AS 一年中的第多少天,
DATENAME(dw, GETDATE()) AS 星期,
DATENAME(week, GETDATE()) AS 周数,
DATENAME(hour, GETDATE()) AS 时,
DATENAME(minute, GETDATE()) AS 分,
DATENAME(second, GETDATE()) AS 秒,
DATENAME(millisecond,GETDATE()) AS 毫秒
2:DatePart 函数:
select getdate() AS 当前时间,
datepart(mm,getdate()) AS 月,
datepart(yy,getDate()) AS 年,
datepart(dd,getdate()) AS 日,
datepart(dy,getdate()) AS 当年第几天,
datepart(wk,getdate()) AS 当年第几周,
datepart(dw,getdate()) AS 当周第几天,
datepart(qq,getdate()) AS 第几季度,
datepart(hh,getdate()) AS 小时,
datepart(mi,getdate()) AS 分钟,
datepart(ss,getdate()) AS 秒