-
Type:
Bug
-
Status: Closed
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: None
-
Fix Version/s: avatica-1.16.0, 1.23.0
-
Labels:None
Floor timestamp to week exist error:
The start day of the week is not Sunday or Monday, calcite use Thursday to split a week.
Example:
sql: select FLOOR(CAST('2017-01-28' AS TIMESTAMP) TO WEEK);
Response:
2017-01-26 00:00:00.0
2017-01-26 is Thursday that is not our expect result. As result, 2017-01-22 is the first day that we expect.
- depends upon
-
CALCITE-3398 Release avatica 1.16.0
-
- Closed
-
- is related to
-
CALCITE-759 Add DayOfWeek and other missing date/time functions
-
- Open
-
-
CALCITE-2303 In EXTRACT function, support MICROSECONDS, MILLISECONDS, EPOCH, ISODOW, ISOYEAR and DECADE time units
-
- Closed
-