Details

    • Sub-task
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • 3.0.0
    • 3.4.0
    • SQL
    • None

    Description

      Currently, Spark does not have support for `to_char`. PgSQL, however, [does|https://www.postgresql.org/docs/12/functions-formatting.html]:

      Query example: 

      SELECT to_char(SUM(n) OVER (ORDER BY i ROWS BETWEEN CURRENT ROW AND 1 FOLLOWING),'999999999999999999999D9')
      
      Function Return Type Description Example
      to_char(timestamptext) text convert time stamp to string to_char(current_timestamp, 'HH12:MI:SS')
      to_char(intervaltext) text convert interval to string to_char(interval '15h 2m 12s', 'HH24:MI:SS')
      to_char(inttext) text convert integer to string to_char(125, '999')
      to_char(double precisiontext) text convert real/double precision to string to_char(125.8::real, '999D9')
      to_char(numerictext) text convert numeric to string to_char(-125.8, '999D99S')

      Attachments

        Activity

          People

            dtenedor Daniel
            DylanGuedes Dylan Guedes
            Votes:
            0 Vote for this issue
            Watchers:
            6 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: