Is there a way to to accomplish selecting only data where a date field is greater than 1 hour ago?
SELECT * FROM MyData WHERE my_date_field > 1 Hour ago EXTRAPOLATE
I know in MySQL and most other RDMS you can do something like
SELECT * FROM MyData WHERE my_date_field > now()- interval 1 hour;
But I have not found a way to duplicate that behavior with NRQL. Does anyone have any way they are able to replicate the MySQL behavior?