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?
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?
KevinBellSLC Aug 31, 2012 12:35 PM
Correct Answer
User Error! I shouldn't program on Friday afternoons! I just had a problem buried in the routine that builds the query.
See the reply in context