--当月第几周SELECT DATEPART(wk,getdate())-DATEPART(wk,DATEADD(dd,-day(getdate()),getdate())) + 1--当周星期几SELECT datename(weekday, getdate())--当前时间(时：分：秒)SELECT CONVERT(varchar(100), GETDATE(), 24)