We have a 10.0 file geodatabase featureclass with a Date field. When we query that field, we sometimes get unexpected results; The query results appear to miss or include records near the threshold.
When we run this query:
"THE_DATE" <= date '2012-06-15 16:00:00'
A record with the following date value is INCLUDED in the query result:
6/15/2012 4:01:50 PM
When we run this query:
"THE_DATE" <= date '2012-06-15 15:50:00'
That same record (6/15/2012 4:01:50 PM) is excluded from the query result (as expected).
