sql - 想要打印申报日期和月份

Question

我想通过以下查询声明月份和日期，但我得到的内容为

1905 年 7 月 21 日上午 12:00

我想要它作为

2015 年 12 月 31 日

下面是我的查询

declare @actualMonth int 
  declare @actualYear int
set  @actualYear = 2015
set @actualMonth = 12
 DECLARE @DATE DATETIME
SET @DATE = CAST(@actualYear +'-' + @actualMonth AS datetime) 
 print  @DATE

这里出了什么问题

Answer 1

这将为您提供预期的输出，

DECLARE @actualMonth INT 
DECLARE @actualYear INT
SET @actualYear = 2015
SET @actualMonth = 12
DECLARE @DATE DATETIME;
SET @DATE = CAST(
        CAST(@actualYear AS VARCHAR)+'-'+CAST(@actualMonth AS VARCHAR)+'-'+'31' 
        AS DATETIME
    );

PRINT Convert(varchar(11),@DATE,109)

试试这个，

SET @DATE = CAST(
        CAST(@actualYear AS VARCHAR)+'-'+CAST(@actualMonth AS VARCHAR)+'-'+ Cast(Day(DATEADD(DAY,-1,DATEADD(month,@actualMonth,DATEADD(year,@actualYear-1900,0)))) AS VARCHAR)
        AS DATETIME
    );

或者这个，

SET @DATE = CAST(
        CAST(@actualYear AS VARCHAR)+'-'+CAST(@actualMonth AS VARCHAR)+'-'+'01' 
        AS DATETIME
    );

PRINT CONVERT(VARCHAR(11), DATEADD(D, -1, DATEADD(M, 1, @DATE)), 109)