Details

    • Type: Sub-task
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.4.0
    • Fix Version/s: 1.5.0
    • Component/s: Table API & SQL
    • Labels:
      None

      Description

      L/RPAD(str,len,padstr) Returns the string str, left/right-padded with the string padstr to a length of len characters. If str is longer than len, the return value is shortened to len characters.

      • Syntax:
        LPAD(str,len,padstr)
      • Arguments
        **str: -
        **len: -
        **padstr: -
      • Return Types
        String
      • Example:
        LPAD('hi',4,'??') -> '??hi'
        LPAD('hi',1,'??') -> 'h'
        RPAD('hi',4,'') -> 'hi'
        RPAD('hi',1,'??') -> 'h'

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                sunjincheng121 sunjincheng
                Reporter:
                sunjincheng121 sunjincheng
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: