The <= operator in the Advanced Search does not yield the correct result in Issue Navigator

Steps to reproduce

1. An issue was resolved on the date 2012-08-10 16:31
2. The following query is used to search for the issue:

   resolutiondate >= '2012-08-06' and resolutiondate <= '2012-08-10'
   

3. The issue is not displayed on Issue Navigator
4. However, using the following query works fine:

   resolutiondate >= '2012-08-06' and resolutiondate <= '2012-08-10 22:00'
   

5. It shows that the <= operator is not working properly

Cause

The reason this occurs is because simply defining a date is interpreted as midnight that day. For example:

• '2012-08-10' actually means '2012-08-10 00:00'

This means that anything that occurs on 2012-08-10 is automatically after 12am that day.