Details
-
Bug
-
Status: Open
-
Critical
-
Resolution: Unresolved
-
5.0-beta
-
None
-
None
Description
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.