Database Reference
In-Depth Information
Figure 9.10
Three Variations
on the Date
Format with
TO_CHAR.
, TO_CHAR(RECORDING_DATE,'DY, MONTH MM, YEAR')
"Spell the year"
FROM SONG;
The next query shows the TO_CHAR function for numbers. Figure
9.11 shows part of the result.
SELECT ARTIST_ID, AMOUNT_CHARGED
,TO_CHAR(AMOUNT_CHARGED,'$9,999,990.00') FORMAT1
,TO_CHAR(AMOUNT_CHARGED,'0999990.9999') FORMAT2
FROM STUDIOTIME;
 
Search WWH ::




Custom Search