Details

    • Technical task
    • Resolution: Unresolved
    • Major
    • None
    • None
    • query
    • 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.
       

      Attachments

        No reviews matched the request. Check your Options in the drop-down menu of this sections header.

        Activity

          People

            simon.dew Simon Dew
            muk.sreenivasan Muk Sreenivasan
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty