All date system columns, such as the CREATE_DATE column, have a granularity of milliseconds. If you use the '=' comparison operator in a query, you must specify the date to a granularity of milliseconds.

For example, the following query does not return results for records created on August 23, 2013 because it does not specify a date with a granularity of milliseconds:

Person.CREATE_DATE = '23/Aug/2013' 

To run a query for a specific date without specifying a granularity of milliseconds, you can run a query on a range for that date.

For example, the following query returns records created on August 23, 2013: