Home Forums SQL Server 2016 SQL Server 2016 - Development and T-SQL SQL query to find the previous date, current date data RE: SQL query to find the previous date, current date data

  • October 25, 2016 at 7:46 am

    #1908610

    Chris Harshman (10/25/2016)

    HanShi (10/24/2016)

    ...

    WHERE x.evntTime > cast(GETDATE()-1 as date)

    since evntTime seems to be DATETIME datatype, wouldn't that leave an implicit conversion in the execution to compare it to the calculated DATE value? If you want to avoid the conversion, maybe something like:

    WHERE x.evntTime > DATEADD(day, DATEDIFF(day, 1, GETDATE()),0)

    Your absolutely right 😎

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **