sql 日期輸出

SELECT '民國'+CAST(DATEPART(YY,GETDATE())-1911 AS VARCHAR)+'年'+CAST(DATEPART(MM,GETDATE()) AS VARCHAR)+'月' + CAST(DATEPART(DD,GETDATE()) AS VARCHAR) +'日 週'+SUBSTRING('日一二三四五六',DATEPART(DW,GETDATE()),1)