The ServiceFeatureTable.QueryFeaturesAsync method returns zero features against a map service for a valid WhereClause expression that uses the equals (=) comparison operator in combination with a DateTime variable, yet the same expression succeeds at the REST endpoint.
SQL queries in ArcGIS should adhere to a set of guidelines that ensures the syntax works across ArcGIS products (services and APIs):
- Date functions are required for date/time queries (for example, timestamp)
- Date formats must be yyyy-mm-dd
- Times should be in 24 hour format
- AM / PM suffix should not be specified
- The seconds fraction (.SSS) should not be specified