Oracle Conversion SRFs and Date Formatting

日期的轉換可參考下表Table 2-15 Datetime Format ElementsElementSpecify in TO_* datetime functions?Description- / , . ; : "text" YesPunctuation and quoted text is reproduced in the result.AD A.D. YesAD indicator with or without periods.AM A.M. YesMeridian indicator with or without periods.BC B.C. YesBC indicator with or without periods.CC SCC NoCentury.If the last 2 digits of a 4-digit year are between 01 and...
訂閱： 文章 (Atom)