gemfire - How to query Apache Geode cache to get the data older than 1 hour? - Stack Overflow

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.