110,534
社区成员
发帖
与我相关
我的任务
分享
l.Date>= SqlFunctions.DateAdd("year",SqlFunctions.DateDiff("year",DateTime.Now.Date,l.Date))
&& l.Date < SqlFunctions.DateAdd("day",6,SqlFunctions.DateAdd("year",SqlFunctions.DateDiff("year",DateTime.Now.Date,l.Date)))
这样不知道行不行DECLARE @Date DATETIME,
@newDate VARCHAR(50)
SET @Date = '2013-10-01'
SET @newDate='-10-03'
SELECT DATEDIFF(d,@Date, CONVERT(VARCHAR,DATEPART(yyyy,@Date))+@newDate)
用SqlFunctions这东西就不知道怎么写了……DateTime >= DateTime.Now.Date.AddDays(-5) && DateTime<= DateTime.Now.Date.AddDays(6)