Let's see how this new format works....
I'm attempting to query against current time in the Field Calculator - ideally what I'm trying to do is come up with a definition query that provides features that are greater than 3 hours old.
What I have is a table from MS Access 2010, that is being delivered to ArcGIS via a database link. All working well.
Each record in the table has an X and Y which is being drawn via an event viewer - all working ok.
Each record also has a timestamp of the time it was created. I wan to be able to separate out records that are greater than 3 hours old, so that they can be drawn in a different colour to highlight their importance.
So far I've discovered the CURRENT_TIMESTAMP SQL operator, but can't seem to get anywhere with it.
Time field in the table is formatted as dd/mm/yyyy hh:mm:ss AM/PM
Is anyone able to provide some clarity on this?