laptop and a wrench

Bogue

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.

Dernière publication: November 21, 2019 ArcGIS for Server
Numéro d’ID de bogue BUG-000095059
EnvoiMarch 17, 2016
Dernière modificationJune 11, 2020
S’applique àArcGIS for Server
Version trouvée10.2.1
Plateforme serveurWindows
Plateforme client7.0 64 Bit
StatutWill Not Be Addressed

Informations supplémentaires

Use the SQL92 standard functions for date and time.

Solution de contournement

Change the date conversion syntax to the one used by a file geodatabase or SQL Server geodatabase to fix the issue.

Étapes pour reproduire

ID de bogue: BUG-000095059

Logiciel:

  • ArcGIS for Server

Obtenir de l’aide auprès des experts ArcGIS

Contacter le support technique

Télécharger l’application Esri Support

Accéder aux options de téléchargement

En savoir plus sur ce sujet