Home Forums SQL Server 7,2000 T-SQL Date Range condition in WHERE clause RE: Date Range condition in WHERE clause

  • July 7, 2008 at 2:29 pm

    #839167

    I am not sure why Mickael's solution will not work. If it is a datetime value the comparison should work. To get your original query to work you need to convert it back to a datetime.

    WHERE Cast(CONVERT(CHAR(10), EffDt, 101) as datetime) between '06/01/2008' and '06/30/2008'