input |
Output |
To_char (Now (), ' Day, HH12:MI:SS ') |
' Tuesday, 05:39:18 ' |
To_char (Now (), ' Fmday, HH12:MI:SS ') |
' Tuesday, 05:39:18 ' |
To_char (-0.1, ' 99.99 ') |
'-.10 ' |
To_char ( -0.1, ' FM9.99 ') |
'-.1 ' |
To_char (0.1, ' 0.9 ') |
' 0.1 ' |
To_char (12, ' 9990999.9 ') |
' 0012.0 ' |
To_char (' FM9990999.9 ') |
' 0012 ' |
To_char (485, ' 999 ') |
' 485 ' |
To_char (-485, ' 999 ') |
'-485 ' |
To_char (485, ' 9 9 9 ') |
' 4 8 5 ' |
To_char (1485, ' 9,999 ') |
' 1,485 ' |
To_char (1485, ' 9g999 ') |
' 1 485 ' |
To_char (148.5, ' 999.999 ') |
' 148.500 ' |
To_char (148.5, ' 999d999 ') |
' 148,500 ' |
To_char (3148.5, ' 9g999d999 ') |
' 3 148,500 ' |
To_char ( -485, ' 999S ') |
' 485-' |
To_char ( -485, ' 999MI ') |
' 485-' |
To_char (485, ' 999MI ') |
' 485 ' |
To_char (485, ' PL999 ') |
' +485 ' |
To_char (485, ' SG999 ') |
' +485 ' |
To_char ( -485, ' SG999 ') |
'-485 ' |
To_char ( -485, ' 9sg99 ') |
' 4-85 ' |
To_char ( -485, ' 999PR ') |
' <485> ' |
To_char (485, ' L999 ') |
' DM 485 |
To_char (485, ' RN ') |
' CDLXXXV ' |
To_char (485, ' FMRN ') |
' CDLXXXV ' |
To_char (5.2, ' FMRN ') |
V |
To_char (482, ' 999th ') |
' 482nd ' |
To_char (485, ' Good number: ' 999 ') |
' Good number:485 ' |
To_char (485.8, ' "Pre-decimal:" 999 "Post-decimal:". 999 ') |
' pre-decimal:485 post-decimal:. 800 ' |
To_char (' 99v999 ') |
' 12000 ' |
To_char (12.4, ' 99v999 ') |
' 12400 ' |
To_char (12.45, ' 99v9 ') |
' 125 ' |
To_char (0.1, ' fm999g999g999g999g999g999g999g999g990d0 ') 0.1
Number format mask problem in HTML reports (TO_CHAR)