IF LEN(@CreateTime) = 8 --1. 完整日期
BEGIN
SET @betime = CONVERT(VARCHAR(100), @CreateTime, 23)
SET @entime = CONVERT(VARCHAR(100), @CreateTime, 23)
PRINT 'a'
PRINT @betime
END
ELSE
IF LEN(@CreateTime) = 6 --2. 日期到月
BEGIN
SET @betime = CONVERT(VARCHAR(100), @CreateTime + '01', 23)
SET @entime = DATEADD(DAY, -1,
DATEADD(MONTH, 1,
CAST(( LEFT(@CreateTime, 4)
+ '-'
+ SUBSTRING(@CreateTime,
5,
LEN(@CreateTime))
+ '-' + '01' ) AS DATETIME)))
END
ELSE
IF LEN(@CreateTime) = 4 --3. 日期到年
BEGIN
SET @betime = CONVERT(VARCHAR(100), @CreateTime
+ '0101', 23)
SET @entime = CONVERT(VARCHAR(100), @CreateTime
+ '1231', 23)
END
BEGIN
SET @betime = CONVERT(VARCHAR(100), @CreateTime, 23)
SET @entime = CONVERT(VARCHAR(100), @CreateTime, 23)
PRINT 'a'
PRINT @betime
END
ELSE
IF LEN(@CreateTime) = 6 --2. 日期到月
BEGIN
SET @betime = CONVERT(VARCHAR(100), @CreateTime + '01', 23)
SET @entime = DATEADD(DAY, -1,
DATEADD(MONTH, 1,
CAST(( LEFT(@CreateTime, 4)
+ '-'
+ SUBSTRING(@CreateTime,
5,
LEN(@CreateTime))
+ '-' + '01' ) AS DATETIME)))
END
ELSE
IF LEN(@CreateTime) = 4 --3. 日期到年
BEGIN
SET @betime = CONVERT(VARCHAR(100), @CreateTime
+ '0101', 23)
SET @entime = CONVERT(VARCHAR(100), @CreateTime
+ '1231', 23)
END