How to search a field defined as datetime RRS feed

  • Question

  • I have a field called datecase defined as datetime.  I would like to get the results for searching the field using:

    select datecase from db where datecase between '2009-11-01' and '2010-10-31'

    However, there is no error on this statement, but I received timeout expired.

    Why is this so?  Please help.




    Tuesday, April 19, 2011 4:44 PM