topic Re: Date query on File GDB in Python Questions

Date query on File GDB

KevinBell — Fri, 31 Aug 2012 17:08:59 GMT

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?

Re: Date query on File GDB

KevinYanuk — Sat, 11 Dec 2021 12:11:57 GMT

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

Re: Date query on File GDB

KevinBell — Fri, 31 Aug 2012 19:18:14 GMT

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.

Re: Date query on File GDB

KevinBell — Fri, 31 Aug 2012 19:35:13 GMT

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