Oracletochar的用法的描述

 　以下的文章主要是对Oracle to_char 的用法的描述，相对而言Oracle to_char能在很短的时间里被广泛的应用，说明它的可实际应用性还是占优势的，以下就是文章的具体内容的介绍，希望你会有所收获。
The following are number examples for the to_char function.

　　2.to_char(1210.73, '9999.9') would return '1210.7'

　　3.to_char(1210.73, '9,999.99') would return '1,210.73'

　　4.to_char(1210.73, '$9,999.00') would return '$1,210.73'

　　5.to_char(21, '000099') would return '000021'

　　6.The following is a list of valid parameters when

　　the to_char function is used to convert a date to a string.

　　These parameters can be used in many combinations.

　　7.Parameter Explanation

　　8.YEAR Year, spelled out

　　9.YYYY 4-digit year

　　10.YYY

　　11.YY

　　12.Y Last 3, 2, or 1 digit(s) of year.

　　13.IYY

　　14.IY

　　15.I Last 3, 2, or 1 digit(s) of ISO year.

　　16.IYYY 4-digit year based on the ISO standard

　　17.Q Quarter of year (1, 2, 3, 4; JAN-MAR = 1).

　　18.MM Month (01-12; JAN = 01).

　　19.MON Abbreviated name of month.

　　20.MONTH Name of month, padded with blanks to length of 9 characters.

　　21.RM Roman numeral month (I-XII; JAN = I).

　　22.WW Week of year (1-53) where week 1 starts on the first day of the year and continues to the seventh day of the year.

　　23.W Week of month (1-5) where week 1 starts on the first day of the month and ends on the seventh.

　　24.IW Week of year (1-52 or 1-53) based on the ISO standard.

　　25.D Day of week (1-7).

　　26.DAY Name of day.

　　27.DD Day of month (1-31).

　　28.DDD Day of year (1-366).

　　29.DY Abbreviated name of day.

　　30.J Julian day; the number of days since January 1, 4712 BC.