Details
Minor Description
Query:
SELECT DATE_RANGE_STR('2006-01-02T15:04:05.999', '2016-01-02T15:04:05.999-08:00', 'quarter') AS Quarters;
|
This query doesn't give any results in CBAS which N1QL returns results following the first date format in DATE_RANGE_STR function.
N1QL output:
[
|
{
|
"Quarters": [
|
"2006-01-02T15:04:05.999",
|
"2006-04-02T15:04:05.999",
|
"2006-07-02T15:04:05.999",
|
"2006-10-02T15:04:05.999",
|
"2007-01-02T15:04:05.999",
|
"2007-04-02T15:04:05.999",
|
"2007-07-02T15:04:05.999",
|
"2007-10-02T15:04:05.999",
|
"2008-01-02T15:04:05.999",
|
"2008-04-02T15:04:05.999",
|
"2008-07-02T15:04:05.999",
|
"2008-10-02T15:04:05.999",
|
"2009-01-02T15:04:05.999",
|
"2009-04-02T15:04:05.999",
|
"2009-07-02T15:04:05.999",
|
"2009-10-02T15:04:05.999",
|
"2010-01-02T15:04:05.999",
|
"2010-04-02T15:04:05.999",
|
"2010-07-02T15:04:05.999",
|
"2010-10-02T15:04:05.999",
|
"2011-01-02T15:04:05.999",
|
"2011-04-02T15:04:05.999",
|
"2011-07-02T15:04:05.999",
|
"2011-10-02T15:04:05.999",
|
"2012-01-02T15:04:05.999",
|
"2012-04-02T15:04:05.999",
|
"2012-07-02T15:04:05.999",
|
"2012-10-02T15:04:05.999",
|
"2013-01-02T15:04:05.999",
|
"2013-04-02T15:04:05.999",
|
"2013-07-02T15:04:05.999",
|
"2013-10-02T15:04:05.999",
|
"2014-01-02T15:04:05.999",
|
"2014-04-02T15:04:05.999",
|
"2014-07-02T15:04:05.999",
|
"2014-10-02T15:04:05.999",
|
"2015-01-02T15:04:05.999",
|
"2015-04-02T15:04:05.999",
|
"2015-07-02T15:04:05.999",
|
"2015-10-02T15:04:05.999"
|
]
|
}
|
]
|
Attachments
| For Gerrit Dashboard: MB-28964 | ||||||
|---|---|---|---|---|---|---|
| # | Subject | Branch | Project | Status | CR | V |
| 105277,3 | MB-28964: Handle timezones in dateTime range function. | master | cbas-core | Status: MERGED | +2 | +1 |