Home Forums SQL Server 2005 SQL Server Newbies datediff include 1 hour before midnight RE: datediff include 1 hour before midnight

  • April 8, 2014 at 11:06 am

    #1704216

    awcrestview (4/8/2014)

    Hi,

    I need to find all records for all 3 shifts in 1 day and the datediff below does not include the 1 hour before midnight (missing 1 hour for graveyard shift).

    where DateDiff(day, Start_DateTime, '2014-04-07')=0 AND DateDiff(day, End_DateTime, '2014-04-07')=0

    Thank You for you time.

    Based on the date 2014-04-07 what are the dates and times of the shifts you are trying to return.