AnsweredAssumed Answered

Querying against current time in Field Calculator / Def Query

Question asked by leftieant76 on Aug 27, 2014
Latest reply on Aug 31, 2014 by leftieant76



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?