d , dd | Day, two digit day of the month: 1 … 31 and 01 … 31, respectively |
ddd , dddd | Abbreviated and full name of the day of the week. |
f … fffffff | The tenths of a second … the ten millionths of a second |
F … FFFFFFF | If non-zero: the tenths of a second … the tenths millionths of a second in a date and time value. |
FFFFFFF | If non-zero, the ten millionths of a second in a date and time value. |
g , gg | The period or era. (for example A.D. ) |
h , hh | The hour and two digit hour using a 12-hour clock (1 … 12 and 01 … 12, respectively) |
H , HH | The hour and two digit hour using a 24-hour clock (1 … 24 and 01 … 24, respectively) |
K | Time zone information, for example +01:00 . Cannot be only specifier in format string. |
m , mm | The minute or two digit minute (0 … 59 and 00 … 59, respectively) |
M , MM | The month, 1 … 12 and 01 … 12, respectively |
MMM , MMMM | Abbreviated and full name of the month |
s , ss | Seconds, 0 … 59 and 00 … 59, respectively |
t , tt | The first character, both characters of AM or PM |
y , yy | year, 0 … 99 and 00 … 99, respectively |
yyy | year with a minimum of three digits. |
yyyy , yyyyy | four and five digit year |
z , zz | Hours offset from UTC UTC |
zzz | Hours and minutes offset from UTC. |
: | The time separator. |
"/" | The date separator. |
"string" , 'string' | Literal string delimiter. |
% | Defines the following character as a custom format specifier. |
\ | The escape character. |
All other characters are not intepreted.