[
https://issues.apache.org/jira/browse/KYLIN-5791?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
pengfei.zhan resolved KYLIN-5791.
---------------------------------
Fix Version/s: 5.0.0
Assignee: Zhimin Wu
Resolution: Fixed
> Using CAST function to convert timestapadd to varchar does not return the
> result in the required time format
> ------------------------------------------------------------------------------------------------------------
>
> Key: KYLIN-5791
> URL: https://issues.apache.org/jira/browse/KYLIN-5791
> Project: Kylin
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 5.0-beta
> Reporter: Zhimin Wu
> Assignee: Zhimin Wu
> Priority: Critical
> Fix For: 5.0.0
>
>
> Query statement: SELECT CAST(TIMESTAMPADD(MONTH, -1, TO_DATE('2023-07-31',
> 'yyyy-MM-dd')) AS VARCHAR)
> The result of the TIMESTAMPADD function here is 2023-06-30, but when using
> the CAST function for conversion, it becomes 2023-06-30 00:00:00.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
