Bug
The Query Builder in ArcMap is not using the correct SQL syntax when performing a date query on a feature class that is stored in Oracle (ST_GEOMETRY)
| Bug ID Number | NIM071384 |
|---|---|
| Submitted | August 4, 2011 |
| Last Modified | April 2, 2025 |
| Applies to | ArcSDE/Enterprise Geodatabase |
| Version found | 10.0 |
| Version Fixed | 10.1 |
| Status | Fixed |
Additional Information
Tested on 10.1 final. Does not reproduce.Workaround
Altered the query as below DT= To_Date '2011-07-27 12.09.13 AM'Steps to Reproduce
Bug ID: NIM071384
Software:
- ArcSDE/Enterprise Geodatabase
Get notified when the status of a bug changes
Discover more on this topic
Search for related information
Find training related to this topic
Explore ideas and give feedback
Get help from ArcGIS experts
Download the Esri Support App