In Apache Geode (gemfire), I have a object which has field called CreatedOn (sample value 2025-03-02) and createdAt(07:15:20). I want to query over Gemfire region to get the all records/data which is older than 1 hr from the current date. How can we do that?
select * from /Sampleregion where system = 'ABC' and status = 'DRAFT' and createdOn = TO_DATE('2025-02-03','yyyy-MM-dd')
Here I'm only intersted to get last 1 hour records.