Bug
Versions prior to ArcGIS Desktop 10.3.1, generate the error message, "An invalid syntax was used" when using the TO_DATE function for the Select by Attributes tool on a feature class in an Oracle geodatabase which has more than one join and one of the joined tables contains a date field.
| Bug ID Number | BUG-000095059 |
|---|---|
| Submitted | March 17, 2016 |
| Last Modified | June 11, 2020 |
| Applies to | ArcGIS for Server |
| Version found | 10.2.1 |
| Operating System | Windows |
| Operating System Version | 7.0 64 Bit |
| Status | Will Not Be Addressed |
Additional Information
Use the SQL92 standard functions for date and time.Workaround
Change the date conversion syntax to the one used by a file geodatabase or SQL Server geodatabase to fix the issue.Steps to Reproduce
Bug ID: BUG-000095059
Software:
- ArcGIS for Server
Get help from ArcGIS experts
Download the Esri Support App
Discover more on this topic
Search for related information
Find training related to this topic
Explore ideas and give feedback