topic Re: Query Against Date Field of File Geodatabase (10.0) Returning Unexpected Result in Data Management Questions https://community.esri.com/t5/data-management-questions/query-against-date-field-of-file-geodatabase-10-0/m-p/378308#M21516 <HTML><HEAD></HEAD><BODY><SPAN>This stopped occurring when we installed SP5 (10.0).</SPAN></BODY></HTML> Fri, 13 Jul 2012 14:50:46 GMT IvanBrown 2012-07-13T14:50:46Z Query Against Date Field of File Geodatabase (10.0) Returning Unexpected Result https://community.esri.com/t5/data-management-questions/query-against-date-field-of-file-geodatabase-10-0/m-p/378307#M21515 <HTML><HEAD></HEAD><BODY><SPAN>We have a 10.0 file geodatabase featureclass with a Date field.&nbsp; When we query that field, we sometimes get unexpected results;&nbsp; The query results appear to miss or include records near the threshold.</SPAN><BR /><BR /><SPAN>When we run this query:</SPAN><BR /><BR /><SPAN>&nbsp;&nbsp; "THE_DATE" &lt;= date '2012-06-15 16:00:00'</SPAN><BR /><BR /><SPAN>A record with the following date value is INCLUDED in the query result:</SPAN><BR /><BR /><SPAN>&nbsp;&nbsp; 6/15/2012 4:01:50 PM</SPAN><BR /><BR /><SPAN>When we run this query:</SPAN><BR /><BR /><SPAN>&nbsp;&nbsp; "THE_DATE" &lt;= date '2012-06-15 15:50:00'</SPAN><BR /><BR /><SPAN>That same record (6/15/2012 4:01:50 PM) is excluded from the query result (as expected).</SPAN></BODY></HTML> Mon, 18 Jun 2012 13:24:17 GMT https://community.esri.com/t5/data-management-questions/query-against-date-field-of-file-geodatabase-10-0/m-p/378307#M21515 IvanBrown 2012-06-18T13:24:17Z Re: Query Against Date Field of File Geodatabase (10.0) Returning Unexpected Result https://community.esri.com/t5/data-management-questions/query-against-date-field-of-file-geodatabase-10-0/m-p/378308#M21516 <HTML><HEAD></HEAD><BODY><SPAN>This stopped occurring when we installed SP5 (10.0).</SPAN></BODY></HTML> Fri, 13 Jul 2012 14:50:46 GMT https://community.esri.com/t5/data-management-questions/query-against-date-field-of-file-geodatabase-10-0/m-p/378308#M21516 IvanBrown 2012-07-13T14:50:46Z