Uploaded image for project: 'Couchbase Server'
  1. Couchbase Server
  2. MB-30150

Incorrect query result for select millis_to_str(str_to_millis('2010-01-01')) as date

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Minor
    • 6.0.0
    • 5.5.0
    • analytics
    •  5.5.0-2907
    • Untriaged
    • Centos 64-bit
    • No
    • CX Sprint 107, CX Sprint 108

    Description

      Difference in query results between Query workbench and Analytics. Date result is shown one day less on Analytics.

      (On Query Workbench)
      select millis_to_str(str_to_millis('2010-01-01')) as date
      [
       {
       "date": "2010-01-01T00:00:00-08:00"
       }
      ]

      (On Analytics)
      select millis_to_str(str_to_millis('2010-01-01')) as date;
      [
       {
       "date": "2009-12-31T16:00:00-08:00"
       }
      ]

      Attachments

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

        Activity

          People

            dmitry.lychagin Dmitry Lychagin (Inactive)
            tanzeem.ahmed Tanzeem Ahmed (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty