Uploaded image for project: 'IMPALA'
  1. IMPALA
  2. IMPALA-9600

Support Format Modifiers for String Conversion

    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Epic Color:
      ghx-label-10

      Description

      A lack of support for "format modifiers" or "template patterns" while converting numeric and potentially other types to strings is a hinderance on usability.

      There may not be a way to do this as part of the SQL Standard, most database have a common extension to type conversion functions such as CONVERT() CAST() or TO_CHAR() that take a "printf" style format string as an argument. Locale awareness may have to be taken into consideration.

      For example Postgresql uses this syntax to add a thousand separator:

      to_char(148.5, '999D999')

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              superdupershant Shant Hovsepian
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated: