Flexible Search Query to to retrive result before 10 minutes from the current time

[Former Member]

We are required to retrive order details whose creation date is less than 10 minutes from the system date. Order details are present in "ORDERS" table and "CREATIONDATE" is the field.

Please helip us with the syntax of the query.

[Former Member]

I have also facing the same problem. Please help us.

[Former Member]

Hi Sauvik,

I am not sure which database you are using. If you are using oracle then check below solution it should work. In Oracle we have some calculations

Using that you can write a query to get the data as given below

 select {o:saporderid},{o:date} from {Order as o} 
 where  SYSDATE + 10/1440 >= sysdate

`above code return the orders which are created before 10mins from now