SELECT GETDATE() AS '当前日期'
SELECT DATENAME(YEAR,GETDATE()) AS '年'
SELECT DATENAME(month,GETDATE ()) AS '月'
SELECT DATENAME(DAY ,GETDATE ()) AS '日'
SELECT DATENAME(dw,GETDATE ()) AS '星期'
SELECT DATENAME(week,GETDATE ()) AS '周数'
SELECT DATENAME(HOUR ,GETDATE ()) AS '时'
SELECT DATENAME(MINUTE ,GETDATE ()) AS '分'
SELECT DATENAME(SECOND ,GETDATE ()) AS '秒'
SELECT DATEPART(YEAR,GETDATE()) AS '年'
SELECT DATEPART(month,GETDATE ()) AS '月'
SELECT DATEPART(DAY ,GETDATE ()) AS '日'
SELECT DATEPART(dw,GETDATE ()) AS '星期'
SELECT DATEPART(week,GETDATE ()) AS '周数'
SELECT DATEPART(HOUR ,GETDATE ()) AS '时'
SELECT DATEPART(MINUTE ,GETDATE ()) AS '分'
SELECT DATEPART(SECOND ,GETDATE ()) AS '秒'
SELECT DATENAME(YEAR,GETDATE()) AS '年'
SELECT DATENAME(month,GETDATE ()) AS '月'
SELECT DATENAME(DAY ,GETDATE ()) AS '日'
SELECT DATENAME(dw,GETDATE ()) AS '星期'
SELECT DATENAME(week,GETDATE ()) AS '周数'
SELECT DATENAME(HOUR ,GETDATE ()) AS '时'
SELECT DATENAME(MINUTE ,GETDATE ()) AS '分'
SELECT DATENAME(SECOND ,GETDATE ()) AS '秒'
SELECT DATEPART(YEAR,GETDATE()) AS '年'
SELECT DATEPART(month,GETDATE ()) AS '月'
SELECT DATEPART(DAY ,GETDATE ()) AS '日'
SELECT DATEPART(dw,GETDATE ()) AS '星期'
SELECT DATEPART(week,GETDATE ()) AS '周数'
SELECT DATEPART(HOUR ,GETDATE ()) AS '时'
SELECT DATEPART(MINUTE ,GETDATE ()) AS '分'
SELECT DATEPART(SECOND ,GETDATE ()) AS '秒'