Uploaded image for project: 'Kylin'
  1. Kylin
  2. KYLIN-5791

Using CAST function to convert timestapadd to varchar does not return the result in the required time format

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Critical
    • Resolution: Unresolved
    • 5.0-beta
    • None
    • Query Engine
    • 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.

      Attachments

        Activity

          People

            Unassigned Unassigned
            Jueyi Zhimin Wu
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated: