laptop and a wrench

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 (SDO_GEOMETRY).

Last Published: August 25, 2014 ArcSDE/Enterprise Geodatabase
Bug ID Number NIM042750
SubmittedFebruary 24, 2009
Last ModifiedApril 2, 2025
Applies toArcSDE/Enterprise Geodatabase
Version found9.3
Operating SystemWindows OS
Operating System VersionXP
StatusNon-Reproducible

Additional Information

No Public Explanation

Workaround

change syntax (adding TO_DATE manually) would work.

Steps to Reproduce

Bug ID: NIM042750

Software:

  • ArcSDE/Enterprise Geodatabase

Get notified when the status of a bug changes

Download the Esri Support App

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options