New answers tagged query-layer
I would use the Select tool and then write this expression: "Modified_date" >= CURRENT_DATE -1 It should return all your records greather than equal today minus 1 day (i.e. 24 hous), therefore yesterday at 6am. It definitely works with the Definition Query SQL as we use it in our organisation to only view our "incidents" in the last fortnight: ...
In the query you used to define the Query Layer, you could cast this bigint column to another type that is supported by ArcGIS. SELECT CAST(yourbigintcolumn as float)
Top 50 recent answers are included