You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@calcite.apache.org by "Danny Chen (Jira)" <ji...@apache.org> on 2019/10/15 07:08:00 UTC
[jira] [Commented] (CALCITE-3412) Response Error for FLOOR
TIMESTAMP TO WEEK
[ https://issues.apache.org/jira/browse/CALCITE-3412?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16951666#comment-16951666 ]
Danny Chen commented on CALCITE-3412:
-------------------------------------
I'm curious what is the right start day of a week, Sunday ?
> Response Error for FLOOR TIMESTAMP TO WEEK
> -------------------------------------------
>
> Key: CALCITE-3412
> URL: https://issues.apache.org/jira/browse/CALCITE-3412
> Project: Calcite
> Issue Type: Bug
> Components: core
> Environment: mac,linux
> Reporter: huaicui
> Priority: Major
> Attachments: image-2019-10-15-13-33-34-896.png
>
> Original Estimate: 24h
> Remaining Estimate: 24h
>
> The start day of the week is not Sunday or Monday, calcite use Tuesday to split a week, like this:
> select FLOOR(CAST('2017-01-28' AS TIMESTAMP) TO WEEK);
> The response is :
> 2017-01-26 00:00:00.0
> 2017-01-26 is Tuesday.
>
>
--
This message was sent by Atlassian Jira
(v8.3.4#803005)