I'm currently consuming a REST endpoint from ArcGIS Online in ArcMap. I would like to be able to apply a definition query to the layer to select records that are only (for example) less than 24 hours old. Editor tracking is enabled on the feature service, so I have automatically populated fields for 'CreationDate' and 'EditDate'. These times are recorded in UTC.
I cannot work out the SQL syntax to make this occur - in particular how to access 'current time' (which in my circumstance will need to be current time in UTC).
Is anyone able to assist with this?