[jira] [Created] (KYLIN-5791) Using CAST function to convert timestapadd to varchar does not return the result in the required time format

[zhimin wu (Jira)]

zhimin wu created KYLIN-5791:
--------------------------------

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


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)