sql-server - 比较来自参数的两个日期的条件，如果满足则添加

Question

这是我的程序，我在程序中得到从到日期我必须检查 FROM 和 TO 日期之间的差异是否大于 2

如果条件满足，我必须从天数中添加 2 天并将其设置为 TODATE

ALTER PROCEDURE [dbo].[sp_TU_AvgStdDev_Report] 
@FromDate as Datetime,
@ToDate as Datetime,
@RecipeCode as Varchar(8000),
@Grade as Varchar(10),
@WcID as Int
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
SET NOCOUNT ON;
IF (condition to check if @FromDate - @ToDate  > 2)
--if it satisfies
SET @ToDate to @fromDate+2Days

请帮我弄清楚...

Answer 1

为此您需要使用日期函数。

ALTER PROCEDURE [dbo].[sp_TU_AvgStdDev_Report] 
@FromDate as Datetime,
@ToDate as Datetime,
@RecipeCode as Varchar(8000),
@Grade as Varchar(10),
@WcID as Int
AS
BEGIN
IF (datediff(day,@FromDate,@ToDate)>2)
SET @ToDate =  DATEADD(day,2, @fromDate)