The following format mask elements allow you to override the default format masks.
Character |
Returns |
---|---|
D |
Digit for the day (1-7) |
DY |
Name of the day (abbreviated) |
DAY |
Name of the day (padded with blanks to the length of 9 characters) |
WW |
Digit for the week, calculated by the algorithm int((day-jan1)/7) |
IW |
Digit of the ISO week |
MON |
Name of the month (abbreviated) |
MONTH |
Name of the month (padded with blanks to the length of 9 characters) |
RM |
Character for the Roman numeral month |
I,IY,IYY,IYYYY |
Last one, two, or three digits of the ISO year or the ISO year, respectively |
BC,AD,B.C.,A.D. |
BC or AD indicator (with or without periods) |
AM,PM,A.M.,P.M. |
AM or PM indicator (with or without periods) |
For more information on ISO and its date format masks, see the Oracle Server SQL Reference.
Character |
Returns |
---|---|
C |
International currency symbol |
L |
Local currency symbol |
D |
Decimal separator |
G |
Group (thousands) separator |