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?

Find more posts tagged with

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

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

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