SQL/MX 3.2.1 Reference Manual (H06.26+, J06.15+)

SQL/MX Functions and Expressions
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-004
8-185
Examples of TO_CHAR(<NUMERIC>)
Examples of TO_CHAR(<NUMERIC>)
TO_CHAR(<DATETIME>) Function
The TO_CHAR(<DATETIME>)function converts datetime data to formatted string. The
result string is VARCHAR type.
The following is the function syntax:
datetime-expression
is an expression of datetime value which can be DATE or TIMESTAMP.NULL or
dynamic parameter cannot be used for datetime-expressions.
format-value
Expression Result
TO_CHAR(-12.24, '99.99MI') ‘12.24-’
TO_CHAR(250, 'RN') ‘CCL’
TO_CHAR(25, 'FM009999') ‘000025’
TO_CHAR(-25, 'FM009999PR') ‘<000025>’
TO_CHAR(156.25, 'FML9999.99') ‘$156.25’
TO_CHAR(156.25, 'S9999.99') ‘+156.25’
TO_CHAR(148.5, '999D999S') ‘148.500+’
TO_CHAR(12, '99V999') ‘ 12000’
TO_CHAR(12.4, '99V999') ‘ 12400’
TO_CHAR(12.54, '99V9') ‘ 125’
TO_CHAR(datetime-expression, format-value)