You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@calcite.apache.org by "huaicui (Jira)" <ji...@apache.org> on 2019/10/15 05:35:00 UTC

[jira] [Created] (CALCITE-3412) Response Error for FLOOR TIMESTAMP TO WEEK

huaicui created CALCITE-3412:
--------------------------------

             Summary: 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: 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

 

!image-2019-10-15-13-33-34-896.png!
            Reporter: huaicui
         Attachments: image-2019-10-15-13-33-34-896.png





--
This message was sent by Atlassian Jira
(v8.3.4#803005)