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; } } }

Date query on File GDB

KevinBell

I'm getting aggravating results trying to query a date time field in a fgdb...

If I use this:

"gpstime" > date '2011-06-14 10:00:00' AND "gpstime" < date '2011-06-14 11:00:00'

in the select by attributes dialog in arcmap it works fine, but using it as the whereclause in
arcpy.SelectLayerByAttribute i get the wrong times.

ideas?

Vind meer berichten getagd met

Accepted answers

KevinBell

User Error! I shouldn't program on Friday afternoons! I just had a problem buried in the routine that builds the query.

All comments

KevinBell

User Error! I shouldn't program on Friday afternoons! I just had a problem buried in the routine that builds the query.

KevinBell

I am actually passing it in as a variable. I build the string up programmatically and print the whereclause using addMessage and this is how it prints out, which works if using the query builder.

KevinYanuk

I'm getting aggravating results trying to query a date time field in a fgdb...

If I use this:

"gpstime" > date '2011-06-14 10:00:00' AND "gpstime" < date '2011-06-14 11:00:00'

in the select by attributes dialog in arcmap it works fine, but using it as the whereclause in
arcpy.SelectLayerByAttribute i get the wrong times.

ideas?

There might be an issue with the quotations. You could try to set it as a string variable, and passing the variable as the query:

query = "\"gpstime\" > date '2011-06-14 10:00:00' AND \"gpstime\" < date '2011-06-14 11:00:00'"

arcpy.SelectLayerByAttributes_management(lyr, "NEW_SELECTION", query)

edit: notice the slashes I used in the query string to ignore ending the full string

Doe mee aan het gesprek

Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.

Snelle Links

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