EXEMPLOS FORMATAÇÃO DATAS

Format String                                                                 Resultado

MONTH DD, YYYY                      FEBRUARY 05, 1968
MM/DD/YYYY                          02/05/1968

MM-DD-YYYY                          02-05-1968

DD/MM/YYYY                          05/02/1968

DAY MON, YY AD                      MONDAY FEB, 68 AD

DDSPTH "of" MONTH, YEAR A.D.        FIFTH of FEBRUARY,
                                    NINETEEN SIXTY-EIGHT A.D.
CC, SCC                             20, 20
Q                                   1

YYYY, IYYY, RRRR, SYYYY, Y,YYY,     1968, 1968, 1968, 1968,1,968,

YYY, IYY, YY, IY, RR, Y, I,         968, 968, 68, 68, 68, 8, 8,

YEAR,                                                                               NINETEEN SIXTY-EIGHT,

Year                                Nineteen Sixty-Eight
MM, MONTH, Month,                   02, FEBRUARY, February,

MON, Mon, RM                        FEB, Feb, II

WW, IW, W                           06, 06, 1

DDD, DD, DAY,  0                    36, 05, MONDAY,

Day, DY, Dy, J                      Monday, MON, Mon, 2439892

ddTH, DDTH, ddSP, DDSP, DDSPTH      05th, 05TH, five, FIVE, FIFTH



SELECT TO_CHAR(SYSDATE, 'fmDDTH')||' of '||TO_CHAR
(SYSDATE, 'fmMonth')||', '||TO_CHAR(SYSDATE, 'YYYY') "Ides"
FROM DUAL;

9TH of September, 2015