Home Forums SQL Server 2005 T-SQL (SS2K5) Getting datepart to work for query RE: Getting datepart to work for query

  • June 27, 2009 at 10:53 pm

    #1016476

    select

    *

    from

    MyTable

    where

    -- Greater than or equal to yesterday at 04:30

    MyDate >= dateadd(day,datediff(day,0,getdate())-1,'04:30')and

    -- Less than today at 04:30

    MyDate < dateadd(day,datediff(day,0,getdate()) ,'04:30')