sample48.sql

来自「T-SQL示例大全」· SQL 代码 · 共 16 行

/* 文件名称: Sample48.sql */

DECLARE @Now datetime
SET @Now = GETDATE()

SELECT '今天是公元 '+CAST(DATEPART(yy,@Now) AS char(4))+' 年 '+
       RTRIM(CAST(DATEPART(mm,@Now) AS char(2)))+' 月 '+
       RTRIM(CAST(DATEPART(dd,@Now) AS char(2)))+' 日'+
       RTRIM(CAST(DATEPART(hh,@Now) AS char(2)))+' 点 '+
       RTRIM(CAST(DATEPART(mi,@Now) AS char(2)))+' 分 '+
       RTRIM(CAST(DATEPART(ss,@Now) AS char(2)))+' 秒 星期 '+
       RTRIM(CAST((DATEPART(dw,@Now) - 1) AS char(2)))