How to write Between Query in N1QL?


#1

How to write Between Query in N1QL

ex: select * from bucketName where key=‘abcd’ AND (startDate >= ‘2016-07-07T18:00:00’ AND endDate<= ‘2016-07-09T23:59:00’)

like that i have written but the result is coming wrong.


#2

That looks correct. In what way is the result wrong? Can you post a couple of sample documents? What is the difference between the result you are getting and the result you are expecting?


#3

Hi Geraldss,

Thanks for your reply as you said this query is correct. I identified the issue and fixed. That was problem with bucket.