SQL/MX 3.2 Reference Manual (H06.25+, J06.14+)

SQL/MX Functions and Expressions
HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001
9-182
TO_CHAR(<NUMERIC>) Function
C Returns ISO currency symbol;
USD.
Restriction: You can specify the
ISO currency symbol only at the
beginning or end of the
format-value.
12 C999 ‘ USD12’
L Returns local currency symbol
Restriction: You can specify the
local currency symbol only at
the beginning or end of the
format-value. The $
(dollar) is the only supported
local currency symbol.
1234 L9999 ‘ $1234’
MI Returns leading or trailing
minus sign(-).
Restriction: You can specify the
MI only at the beginning or end
of the
format-value.
-1234 9999MI ‘1234-’
PR Returns negative value in <>
brackets and positive value with
leading and trailing blank
spaces
Restriction: You can specify the
PR only at the end of the
format-value.
-1234 9999PR ‘<1234>”
RN
rn
Converts
numeric-
expression
to Roman
numerals in uppercase or
lowercase.
Restriction: You cannot include
other elements with RN or rn.
485 RN
rn
‘CDLXXXV’
‘cdlxxxv’
S Returns a leading or trailing
plus or minus sign.
Restriction: You can specify S
element only at the beginning or
end of the
format-value.
-1245
1266
S9999
S9999
‘-1245’
‘+1266’
Element Description
numeric-
expressi
on
format-
value
Output