[jira] [Updated] (FLINK-24766) Ceiling/flooring dates to day return wrong results

["Flink Jira Bot (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/FLINK-24766?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Flink Jira Bot updated FLINK-24766:
-----------------------------------
    Labels: pull-request-available stale-major  (was: pull-request-available)

I am the [Flink Jira Bot|https://github.com/apache/flink-jira-bot/] and I help the community manage its development. I see this issues has been marked as Major but is unassigned and neither itself nor its Sub-Tasks have been updated for 60 days. I have gone ahead and added a "stale-major" to the issue". If this ticket is a Major, please either assign yourself or give an update. Afterwards, please remove the label or in 7 days the issue will be deprioritized.


> Ceiling/flooring dates to day return wrong results
> --------------------------------------------------
>
>                 Key: FLINK-24766
>                 URL: https://issues.apache.org/jira/browse/FLINK-24766
>             Project: Flink
>          Issue Type: Bug
>          Components: Table SQL / API
>    Affects Versions: 1.14.0
>            Reporter: Sergey Nuyanzin
>            Priority: Major
>              Labels: pull-request-available, stale-major
>
> Query to reproduce
> {code:sql}
> select ceil(date '2021-11-04' to day) as `ceil`,
>        floor(date '2021-11-04' to day) as `floor`;
> {code}
> gives
> {noformat}
> ceil         floor
> 8525-03-02 1970-01-01
> {noformat}
> expected
> {noformat}
> ceil         floor
> 2021-11-05 2021-11-05
> {noformat}



--
This message was sent by Atlassian Jira
(v8.20.1#820001)