Emulates Oracle's TO_CHAR(datetime) function.
| Input |
Output |
Closest
SimpleDateFormat Equivalent |
- / , . ; : "text" |
Reproduced verbatim. |
'text' |
A.D. AD B.C. BC |
Era designator, with or without periods. |
G |
A.M. AM P.M. PM |
AM/PM marker. |
a |
CC SCC |
Century. |
None. |
D |
Day of week. |
u |
DAY |
Name of day. |
EEEE |
DY |
Abbreviated day name. |
EEE |
DD |
Day of month. |
d |
DDD |
Day of year. |
D |
DL |
Long date format. |
EEEE, MMMM d, yyyy |
DS |
Short date format. |
MM/dd/yyyy |
E |
Abbreviated era name (Japanese, Chinese, Thai) |
None. |
EE |
Full era name (Japanese, Chinese, Thai) |
None. |
FF[1-9] |
Fractional seconds. |
S |
FM |
Returns values with no leading or trailing spaces. |
None. |
FX |
Requires exact matches between character data and format model. |
None. |
HH HH12 |
Hour in AM/PM (1-12). |
hh |
HH24 |
Hour in day (0-23). |
HH |
IW |
Week in year. |
w |
WW |
Week in year. |
w |
W |
Week in month. |
W |
IYYY IYY IY I |
Last 4/3/2/1 digit(s) of ISO year. |
yyyy yyy yy y |
RRRR RR |
Last 4/2 digits of year. |
yyyy yy |
Y,YYY |
Year with comma. |
None. |
YEAR SYEAR |
Year spelled out (S prefixes BC years with minus sign). |
None. |
YYYY SYYYY |
4-digit year (S prefixes BC years with minus sign). |
yyyy |
YYY YY Y |
Last 3/2/1 digit(s) of year. |
yyy yy y |
J |
Julian day (number of days since January 1, 4712 BC). |
None. |
MI |
Minute in hour. |
mm |
MM |
Month in year. |
MM |
MON |
Abbreviated name of month. |
MMM |
MONTH |
Name of month, padded with spaces. |
MMMM |
RM |
Roman numeral month. |
None. |
Q |
Quarter of year. |
None. |
SS |
Seconds in minute. |
ss |
SSSSS |
Seconds in day. |
None. |
TS |
Short time format. |
h:mm:ss aa |
TZD |
Daylight savings time zone abbreviation. |
z |
TZR |
Time zone region information. |
zzzz |
X |
Local radix character. |
None. |
See also TO_CHAR(datetime) and datetime format models
in the Oracle documentation.