如何在日期之前进行计算 [英] How Do I Calculte After Before Date

问题描述

当我通过

When i pass

@Reminderdays int=7,
@DayOfReminder int=1,
@MonthOfReminder int=8

他们应该在7天之后给我，即2015年8月7日，



但由于某种原因，它给予了我9-8-2015 ..我不明白如何计算日期，这给了我额外的提前日期

they should give me after 7 days date i.e 7-08-2015 ,

but for some reason it is giving me 9-8-2015 .. I don't understand how the date is getting calculated which is giving me extra ahead date

Declare @company_id int =159,
@IsSendEmailToEmployee bit = 1,
@IsSendEmailToHR bit =0,
@IsSendEmailToManagersManager bit =0,
@IsSendEmailToManager bit=1,
@Reminderdays int=7,
@DayOfReminder int=1,
@MonthOfReminder int=8,
@CompanyYear datetime='2015-04-01'
set @CompanyYear = Convert(datetime,'1 Jan ' + Cast(Year(@CompanyYear) as varchar),101)  



Select Convert(datetime,Convert(varchar(10) ,
DATEADD(dd,+@Reminderdays,DATEADD(dd,@DayOfReminder,DATEADD(Month,@MonthOfReminder-1,@CompanyYear))),101)) as after

推荐答案

对于SQL Server 2012（及以上），请使用DATEFROMPARTS功能 [ ^ ]。

For SQL Server 2012 (and up) use DATEFROMPARTS function[^].

DECLARE @Reminderdays int=7,
DECLARE @DayOfReminder int=1,
DECLARE @MonthOfReminder int=8

SELECT DATEADD(DAY, @DayOfReminder, DATEFROMPARTS(YEAR(GETDATE()), @MonthOfReminder, @DayOfReminder)) AS DayAfterBefore

这篇关于如何在日期之前进行计算的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！