Fetch the data between dates using select query in JDBC receiver

[praveenkva]

Hi Experts,

My requirement is REST to JDBC synchronous scenario using select query statement I need to pull data from database and send response back to REST API.

I have gone through the below article 

https://community.sap.com/t5/technology-blogs-by-members/sap-pi-proxy-to-jdbc-scenario/ba-p/13326556

I am able to receive the response using the select statement in receiver JDBC. However, I need to select the data in certain period like 10 minutes using specific date field. 

Like if I give 02-07-2024 10:00:00 as input date for Select SQL statement then it should fetch data for next 10 minutes using the same date field which is 

Data between 02-07-2024 10:00:00 to 02-07-2024 10:10:00 

Please help.