Hi, I would like to translate below N1QL query into java code using couch base select statements select * from Table_Name where STR_TO_MILLIS(DateTime_ColomnName) <= DATE_ADD_MILLIS(NOW_MILLIS(), -2, ‘hour’) I would really appreciated if somebody can guid me. Thanks in advance!

I am able to translate into Java code. Here is the solution Statement query=Select.select("*").from(i(“Table_Name”)).where(x("ColumnName ").eq(s(ColumnName)) .and(x("ColumnName ").eq(s(“ColumnName”))) .and(strToMillis(“DateTImeColumnName”).lte(dateAddMillis(nowMillis(),-200,Date…

How to write couch base query into java

Java SDK

vsr1 February 27, 2021, 3:00pm 2

check out Couchbase Native to Java N1QL Query

Topic		Replies	Views
How to translate Couchbase query into java code Java SDK	2	706	March 2, 2021
Couchbase Native to Java N1QL Query Java SDK query , n1ql	1	618	February 27, 2021
Spring Data Couchbase\| Prepared Statements does not support Date operations in new upgraded SDK SQL++ query , java , n1ql	13	2403	February 1, 2022
Invoking a N1QL query through java code Java SDK query , java , n1ql	2	735	April 9, 2020
Is there any Java API to use N1QL? SQL++	12	3820	March 21, 2016

How to write couch base query into java

Related topics