Oracle To_char formatting functions

Http://www.cnblogs.com/reborter/archive/2008/11/28/1343195.html

Templates	Description
HH	Number of hours in the day (01-12)
HH12	Number of hours in the day (01-12)
HH24	Number of hours in the day (00-23)
MI	Minutes (00-59)
Ss	Seconds (00-59)
SSSS	Seconds after midnight (0-86399)
AM or a.m. or PM or p.m.	Noon SIGN (uppercase)
Am or a.m. or PM or p.m.	Noon Logo (lowercase)
Y,yyy	Year with commas (4 and more bits)
YYYY	Year (4 and more bits)
YYY	The latter three digits of the year
Yy	The latter two of the years
Y	The last one of the years
BC or B.C. or AD or A.D.	Year identifier (uppercase)
BC or B.C. or ad or A.D.	Year logo (lowercase)
MONTH	Full-length uppercase month name (9 characters)
Month	Full-length mixed-Case Month name (9 characters)
Month	Full-length lowercase month name (9 characters)
MON	Capital Abbreviation month name (3 characters)
Mon	Abbreviated mixed Case month name (3 characters)
Mon	lowercase abbreviation month name (3 characters)
Mm	Month (01-12)
Day	Full capitalization date name (9 characters)
Day	Full-length mixed-Case Date name (9 characters)
Day	Full-Length Lowercase date name (9 characters)
Dy	Abbreviated Capital Date name (3 characters)
Dy	Abbreviated mixed case date name (3 characters)
Dy	Abbreviated Lowercase date name (3 characters)
Ddd	The days of the Year (001-366)
Dd	One months of life (01-31)
D	Days of the Week (1-7;sun=1)
W	Number of weeks in one months
Ww	Number of weeks in a year
Cc	Century (2-bit)
J	Julian Date (dates from January 1, 4712 BC)
Q	Quarter
Rm	Roman numerals Month (I-xii;i=jan)-Uppercase
Rm	Roman numerals Month (I-xii;i=jan)-lowercase

Oracle To_char formatting functions