Why is to_char left padding with spaces?

14 votes

1 answer

6916 views

postgresql cast number-formatting string-representation

                          When ever I use 099 indicating 3 digits 0-padded, I'm getting spaces on the left side.

    SELECT '>' || to_char(1, '099') || ' 001<
    (1 row)

Why is to_char left padding here? Why are there leading spaces?

Asked by Evan Carroll (65502 rep)

Jun 8, 2017, 07:50 PM
Last activity: Jun 8, 2017, 08:39 PM

Why is to_char left padding with spaces?

Related Questions