+6
Using an Esri FGDB Reader (an Esri FGDB FeatureReader) in a Workbench, I would like to apply a where clause using the last_updated field. I believe that because this is a date/time field that it is causing me troubles as I am able to run tests on other fields.
What is the correct syntax to enter a where clause on a date/time field from a FGDB?
+16
It’s a SQL query, but it has its own syntax, seems esri doesn’t implicitly convert strings to dates like other products do... I checked how ArcPro creates a definition query on a date. It should look like:
last_updated > timestamp '2023-03-15 12:00:00'
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.