Home Forums SQL Server 2008 T-SQL (SS2K8) Why does my yesterday query return no results? RE: Why does my yesterday query return no results?

  • October 23, 2012 at 7:47 am

    #1551909

    jerome.morris (10/23/2012)

    SELECT *from SLADB.dbo.DocketTB

    where Docket_EngFinish >=dateadd(d,datediff(d,0, getdate()),-1) AND Docket_EngFinish<dateadd(d,datediff(d,0, getdate()),0)

    This works, is there a better way ?

    Thanks again Chris 🙂

    Yes - cast both sides as DATE

    where CAST(Docket_EngFinish AS DATE) = CAST(GETDATE() AS DATE) - 1

    Does Docket_EngFinish have a time component or is it all 0's?

    “Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw

    For fast, accurate and documented assistance in answering your questions, please read this article.
    Understanding and using APPLY, (I) and (II) Paul White
    Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden