Oracle Database 12c : 12 Conversion function TO_CHAR
TO_CHAR(DATE,'DATE FORMATE'), YYYY : Full year in numbers YEAR : Year spelled out (in English) MM : Two-digit value for the month MONTH : Full name of the month MON : Three-letter abbreviation of the month DY :Three-letter abbreviation of the day of the week DAY :Full name of the day of the week DD : Numeric day of the month HH24 : MI : SS AM DD "of" MONTH FMddspth
TO_CHAR(DATE,'DATE FORMATE'), YYYY : Full year in numbers YEAR : Year spelled out (in English) MM : Two-digit value for the month MONTH : Full name of the month MON : Three-letter abbreviation of the month DY :Three-letter abbreviation of the day of the week DAY :Full name of the day of the week DD : Numeric day of the month HH24 : MI : SS AM DD "of" MONTH FMddspth