Skip to main content

How to format a leading zero

  • February 15, 2013
  • 1 reply
  • 9 views
Forum|alt.badge.img+2
When the output type is numeric, Vertica does not print a leading 0. like vsql=> select 0.123 ; ?column? ---------- .123

    1 reply

    Forum|alt.badge.img+2
    • Anonymous
    • Author
    • Participating Frequently
    • February 15, 2013
    o print a leading zero use a template as shown below. vsql=> select to_char(0.123,'0.000'); to_char --------- 0.123 (1 row) vsql=> select to_char(.123,'0.000'), to_number('.123','0.999'); to_char | to_number ---------+----------- 0.123 | 0.123 Note: Please see Template Patterns for Numeric Formatting in the SQL Reference Manual
    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement