SQL Server DATEPART() 函数

[sql] view plain copy

--语法：DATEPART(datepart,date)
SELECT DATEPART(yy,getdate()) AS '年',
DATEPART(qq,getdate()) AS '季度',
DATEPART(mm,getdate()) AS '月',
DATEPART(dy,getdate()) AS '年中的日',
DATEPART(dd,getdate()) AS '日',
DATEPART(wk,getdate()) AS '周',
DATEPART(dw,getdate()) AS '星期',--一周的第几天（老外周日是第一天）可以用datename(weekday,getdate()) as weekday
DATEPART(hh,getdate()) AS '小时',
DATEPART(mi,getdate()) AS '分钟',
DATEPART(ss,getdate()) AS '秒',
DATEPART(ms,getdate()) AS '毫秒',
datename(weekday,getdate()) as weekday

本站仅提供存储服务，所有内容均由用户发布，如发现有害或侵权内容，请点击举报。