nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Cannot Use Timestamp for Where Clause

CodyPatterson

Hey All,

I'm attempting to query a feature layer using the ArcGIS API for Python, and when using the where clause for a timestamp, I'm getting met with errors, even though it's validating within Select By Attributes in Pro.

where = 'EditDate < timestamp \'2024-06-28 00:00:00.000\''

I have attempted everything in this link, but none have worked, very confused on where I am going wrong here: https://community.esri.com/t5/arcgis-api-for-python-questions/querying-a-date-field-on-a-feature-layer/td-p/852126

Thanks in advance!

Cody

Finde mehr Beiträge mit dem Tag

Accepted answers

All comments

CodyPatterson

Hey @jcarlson

This service currently isn't public unfortunately, it has proprietary information and could not be shared that way, but if there is a public service you are aware of, I can definitely retry the query, or create my own that is blank that I could test with or send over to test with!

Cody

jcarlson

Any chance the service is public? I would be curious to attempt a query.

According to the REST API docs, you're formatting it fine…

https://developers.arcgis.com/rest/services-reference/enterprise/query-feature-service/#date-time-queries

CodyPatterson

Hey @jcarlson

I just attempted that with no success unfortunately, this is coming from AGOL through their Hosted Feature Layers, I'm not entirely confident in the DB behind it unfortunately.

Cody

jcarlson

Try putting the whole thing in double quotes?

"EditDate < timestamp '2024-06-28 00:00:00'"

The SQL expression might be valid, but timestamp formatting will depend on the underlying database. Where is the data coming from? Postgres? MSSQL? A file?

Nimm an der Unterhaltung teil

Angemeldete Mitglieder können Beiträge verfassen, Updates folgen und mehr. Neu hier? Registriere ein kostenloses Konto.

Schnellzugriffe

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.