Why is Oracle's to_char() function adding spaces?

oracle

Solution

The format mask that you are using is fixed width and allows for a minus sign

Problem

Why is Oracle's `to_char()` function adding spaces? ``` select length('012'), length(to_char('012')), length(to_char('12', '000')) from dual; ``` `3, 3, 4`

Original source

Related problems