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.
上次发布: November 21, 2019ArcGIS for Server
漏洞 ID 编号
BUG-000095059
已提交
March 17, 2016
上次修改时间
June 11, 2020
适用范围
ArcGIS for Server
找到的版本
10.2.1
服务器平台
Windows
客户端平台
7.0 64 Bit
状态
Will Not Be Addressed
开发团队已考虑过该问题或请求,并决定不会解决该问题。 问题的“其他信息”部分可能包含进一步说明。
附加信息
Use the SQL92 standard functions for date and time.
解决办法
Change the date conversion syntax to the one used by a file geodatabase or SQL Server geodatabase to fix the issue.