Thread: MS SQL Server General Questions/Correct date intervals for reports and SQL server queries

    
24 October 2008

15:37:45
sergey


Posts: 0

Correct date intervals for reports and SQL server queries

 


--My example for MS SQL Server:

 

declare @startDate datetime, @endDate datetime

set @startDate = getdate()

set @endDate = getdate()

 

set @startDate = convert(varchar, @endDate, 112)

set @endDate = dateadd(ms, -2, dateadd(dd, 1, convert(varchar, @endDate, 112)))

 

select @startDate

select @endDate

 

-- 24/10/2008 15:39:26: post edited by sergey.
    
24 October 2008

17:09:06
sergey


Posts: 0

Re: Correct date intervals for reports and SQL server queries


 


Variant 2:


Create function [dbo].[TruncTime](@d datetime)


returns datetime


as


  begin


    return dateadd(day,datediff(day,0,@d),0)


  end


 


And inside Stored procedures use this function:


 


SET @PaymentDate_OLD = dbo.TruncTime(@PaymentDate_OLD)


SET @PaymentDate_NEW = dbo.TruncTime(@PaymentDate_NEW) + 1