Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

Add weekday part to N1QL datetime functions

Description

It would be nice to update all N1QL datetime functions to accept a "weekday" part which is the English name of the day, in addition to number of the day.

Components

Affects versions

Fix versions

Labels

Environment

None

Release Notes Description

None

blocks

Activity

CB robot April 18, 2017 at 9:41 PM

Build 5.0.0-2670 contains testrunner commit bb3d446b1637d55787a964823dbcee34ff0905a5 with commit message:
: Add test cases for and
https://github.com/couchbase/testrunner/commit/bb3d446b1637d55787a964823dbcee34ff0905a5

CB robot April 12, 2017 at 11:59 PM

Build 4.6.2-3889 contains testrunner commit a5f12d9582944b9e9335189da02bf3408e04739a with commit message:
: Add test cases for and
https://github.com/couchbase/testrunner/commit/a5f12d9582944b9e9335189da02bf3408e04739a

Gerald Sangudi April 12, 2017 at 4:47 PM

Note that WEEKDAY() returns strings, whereas DATE_PART() returns number.

Gerald Sangudi April 12, 2017 at 4:44 PM

Hi , I don't remember the reason we went with a new function, but the functionality is equivalent. You can document the feature as a new function.

Prasad Varakur April 12, 2017 at 4:37 PM

thanks . What is the reason for adding new functions, instead of not adding a new part similar to bunch of other parts to use with date_part_str()/date_part_millis()?

Fixed
Pinned fields
Click on the next to a field label to start pinning.

Details

Assignee

Reporter

Priority

Instabug

Open Instabug

PagerDuty

Sentry

Zendesk Support

Created January 20, 2017 at 12:31 AM
Updated April 18, 2017 at 9:41 PM
Resolved February 4, 2017 at 10:35 PM
Instabug