SQL Server DATEPART() 函数
- --语法: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
|