590
社区成员
发帖
与我相关
我的任务
分享
DECLARE @TIME DATETIME
SET @TIME='2010-03-25'
SELECT
CASE WHEN DATEPART(DD,@TIME)>=26
THEN DATEADD(DD,26-DATEPART(DD,@TIME),@TIME)
ELSE DATEADD(DD,26-DATEPART(DD,@TIME),DATEADD(MM,-1,@TIME)) END,
CASE WHEN DATEPART(DD,@TIME)>=26
THEN DATEADD(DD,-1,DATEADD(MM,1,DATEADD(DD,26-DATEPART(DD,@TIME),@TIME) ))
ELSE DATEADD(DD,25-DATEPART(DD,@TIME),@TIME) END
------------------------------------------------------ ------------------------------------------------------
2010-02-26 00:00:00.000 2010-03-25 00:00:00.000
(所影响的行数为 1 行)