Home Forums SQL Server 2008 T-SQL (SS2K8) event is occurring between today at 1:00am and tomorrow at 12:59am RE: event is occurring between today at 1:00am and tomorrow at 12:59am

  • Something like this, just off the top of my head:

    declare @StartDate datetime,

    @EndDate datetime;

    select

    @StartDate = dateadd(hh, 1,dateadd(dd, datediff(dd, 0, getdate()), 0)),

    @EndDate = dateadd(dd, 1, @StartDate);

    select ...

    from mytable mt

    where mt.someeventdatetime >= @StartDate and mt.someeventdatetime < @EndDate;