Mega Code Archive

 

Categories / Oracle PLSQL / Conversion Functions

 

Convert a negative number into one with a trailing minus sign

SQL> SQL> SELECT   2     TO_CHAR(-1234,'9999MI') result   3  FROM dual; RESUL ----- 1234- SQL>