laptop and a wrench

Bug

The definition query using SQL Date functions fails and returns the error message, "The SQL Expression has invalid syntax" only when applied to a feature class in a file geodatabase.

Last Published: September 9, 2022 ArcGIS Pro
Bug ID Number BUG-000122764
SubmittedMay 31, 2019
Last ModifiedJune 5, 2024
Applies toArcGIS Pro
Version found2.3.2
Operating SystemWindows OS
Operating System Version10.0
StatusKnown Limit

Additional Information

File geodatabases use the SQL-92 standard, so all functions used in expressions must comply with this standard.

Workaround

Apply SQL date function to feature class from ArcGIS Enterprise geodatabase.

Steps to Reproduce

Bug ID: BUG-000122764

Software:

  • ArcGIS Pro

Get notified when the status of a bug changes

Download the Esri Support App

Discover more on this topic

Esri Community

Search for related information

Training

Find training related to this topic

ArcGIS Ideas

Explore ideas and give feedback

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options