Details
-
Technical task
-
Resolution: Unresolved
-
Major
-
None
-
None
-
DOC-2022-S15, DOC-2022-S16, DOC-2022-S17, DOC-2022-S18, DOC-2022-S19, DOC-2022-S20
-
1
Description
Slack Discussion from N1QL channel:
Full Thread: https://couchbase.slack.com/archives/CD1R8GCRE/p1657651285673139
Muk:
our docs refer to that format, so i used that…will drop and retry>
https://docs.couchbase.com/server/7.0/n1ql/n1ql-language-reference/datefun.html#fn-date-diff-strSELECT name, reviews[0].date
FROM `travel-sample`.inventory.hotel
WHERE reviews[0].date BETWEEN “2013-01-01 %” AND “2014-01-01 %“; (edited)
!https://slack-imgs.com/?c=1&o1=wi32.he32.si&url=https%3A%2F%2Fdocs.couchbase.com%2F_%2Fimg%2Ffavicon.ico|width=16,height=16!docs.couchbase.com
[Date Functions | Couchbase Docs|https://docs.couchbase.com/server/7.0/n1ql/n1ql-language-reference/datefun.html#fn-date-diff-str]
N1QL date functions return the system clock value or manipulate the datetime values, which are represented as a string or an integer.