Error
When querying a date field of a SDE geodatabase feature class, the Select By Attribute tool in ArcGIS Pro fails to preface the date being queried with the necessary delimiter ('date').
| Número de ID del error | BUG-000110490 |
|---|---|
| Enviado | December 29, 2017 |
| Última modificación | June 25, 2025 |
| Relacionado con | ArcGIS for Desktop |
| Versión encontrada | 10.5.1 |
| Sistema operativo | Windows OS |
| Versión de sistema operativo | 7.0 64 Bit |
| Estado | Will Not Be Addressed |
Información adicional
We apologize that we were unable to address this issue within the current product support cycle. If the issue continues to affect your work in a supported release, please contact Technical Support.Solución alternativa
Once the query is constructed, click the ‘Switch to Edit SQL Mode’ button if not already in this view, and manually add the word 'date' in front of the date the user is selecting on.Example: Before:superhero.DATA_CREATOR.Time.Date = '2004-05-03 00:00:00' AND (Sheet1$.Name IS NOT NULL OR Sheet1$.Name IS NULL)After:superhero.DATA_CREATOR.Time.Date = date '2004-05-03 00:00:00' AND (Sheet1$.Name IS NOT NULL OR Sheet1$.Name IS NULL)Pasos para reproducir
ID del error: BUG-000110490
Software:
- ArcGIS for Desktop
Recibir notificaciones cuando cambie el estado de un error
Descubrir más sobre este tema
Buscar información relacionada
Encontrar formación relacionada con este tema
Explorar ideas y aportar opiniones
Obtener ayuda de expertos en ArcGIS
Descargar la aplicación de soporte de Esri