Dates can be formatted with a single shortcut character, such as: "G," or a composite of specifiers, such as "HH:mm". If you want to use a single character as a regular specifier and not a shortcut, prefix the string with %. For example: "%m" outputs the unpadded minute instead of the Month+Day.
Table 14. Single Character Shortcut Date Formats
Format | Description |
|---|---|
t | Short Time "4:05 PM" |
T | Long Time "4:05:07 PM" |
d | Short Date "3/9/2013" |
D | Long Date "Friday, March 09, 2013" |
f | Long Date + Short Time "Friday, March 09, 2013 4:05 PM" |
F | Long Date + Long Time "Friday, March 09, 2013 4:05:07 PM" |
g | Short Date + Short Time "3/9/2013 4:05 PM" |
G | Short Date + Long Time "3/9/2013 4:05:07 PM" (default) |
m | Month + Day "March 09" |
y | Month + Year "March, 2013" |
r | RFC 1123 "Fri, 09 Mar 2013 16:05:07 GMT" |
s | Sortable Date/Time "2013-03-09T16:05:07" |
u | Universal Sortable Date/Time "2013-03-09 16:05:07Z" |
Table 15. Date Format Specifiers (more than one character)
Format | Description Examples are for 2013-04-05 04:07:09 PM CST |
|---|---|
yy | Year "13" |
yyyy | Year "2013" |
M | Month "4" |
MM | Month "04" |
MMM | Month "Apr" |
MMMM | Month "April" |
d | Day "5" |
dd | Day "05" |
ddd | Day "Sun" |
dddd | Day "Sunday" |
h | 12-Hour "4" |
hh | 12-Hour "04" |
H | 24-Hour "16" (if 4 AM "4") |
HH | 24-Hour "16" (if 4 AM "04") |
m | Minute "7" |
MM | Minute "07" |
s | Seconds "9" |
ss | Seconds "09" |
f | Fractions of a second (Can be repeated 1-4 times for more precision) |
F | Fractions of a second without trailing zeros (Can be repeated 1-4 times) |
t | AM or PM designator "P" (blank for 24-hour only cultures) |
tt | AM or PM designator "PM" (blank for 24-hour only cultures) |
z | GMT offset "-6" |
zz | GMT offset "-06" |
zzz | GMT offset "-06:00" |
: | Time separator (locale-specific) |
/ | Date separator (locale-specific) |
\<char> | Escape character (<char> is treated as literal output), for example: "{0:HH\h}" outputs "16h" |
Any other character | Copied to output unchanged |