本文介绍了一种使用SQL进行日期格式化的实用方法。通过动态设置当前年份为特定格式，并根据当前日期的月份长度自动填充零，实现了灵活的日期字符串生成。此技巧适用于需要按年月格式输出日期的场景。
DECLARE @casetime NVARCHAR(30);
DECLARE @year NVARCHAR(30);
SET @year ='2015'
IF CAST(@year AS INT) = YEAR(GETDATE())
BEGIN
SET @casetime = CAST(@year AS NVARCHAR(30))+'-'+ (CASE WHEN Len(MONTH(GETDATE()))=1 THEN '0'+ CAST( MONTH(GETDATE()) AS NVARCHAR(30) ) ELSE CAST( MONTH(GETDATE()) AS NVARCHAR(30)) END)+'-01'
END
ELSE
BEGIN
SET @casetime = @year+'-01-01'
END
SELECT @casetime
DECLARE @year NVARCHAR(30);
SET @year ='2015'
IF CAST(@year AS INT) = YEAR(GETDATE())
BEGIN
SET @casetime = CAST(@year AS NVARCHAR(30))+'-'+ (CASE WHEN Len(MONTH(GETDATE()))=1 THEN '0'+ CAST( MONTH(GETDATE()) AS NVARCHAR(30) ) ELSE CAST( MONTH(GETDATE()) AS NVARCHAR(30)) END)+'-01'
END
ELSE
BEGIN
SET @casetime = @year+'-01-01'
END
SELECT @casetime
扫一扫
690
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
