Appendix #2: Date Format Strings

Click to Print
Format specifier Description Examples
“d” The day of the month, from 1 through 31.More information: The “d” Custom Format Specifier. 2009-06-01T13:45:30 -> 12009-06-15T13:45:30 -> 15
“dd” The day of the month, from 01 through 31.More information: The “dd” Custom Format Specifier. 2009-06-01T13:45:30 -> 012009-06-15T13:45:30 -> 15
“ddd” The abbreviated name of the day of the week.More information: The “ddd” Custom Format Specifier. 2009-06-15T13:45:30 -> Mon (en-US)2009-06-15T13:45:30 -> Пн (ru-RU)

2009-06-15T13:45:30 -> lun. (fr-FR)

“dddd” The full name of the day of the week.More information: The “dddd” Custom Format Specifier. 2009-06-15T13:45:30 -> Monday (en-US)2009-06-15T13:45:30 -> понедельник (ru-RU)

2009-06-15T13:45:30 -> lundi (fr-FR)

“f” The tenths of a second in a date and time value. 2009-06-15T13:45:30.6170000 -> 62009-06-15T13:45:30.05 -> 0
“ff” The hundredths of a second in a date and time value. 2009-06-15T13:45:30.6170000 -> 612009-06-15T13:45:30.0500000 -> 00
“fff” The milliseconds in a date and time value. 6/15/2009 13:45:30.617 -> 6176/15/2009 13:45:30.0005 -> 000
“ffff” The ten thousandths of a second in a date and time value. 2009-06-15T13:45:30.6175000 -> 61752009-06-15T13:45:30.0000500 -> 0000
“fffff” The hundred thousandths of a second in a date and time value. 2009-06-15T13:45:30.6175400 -> 617546/15/2009 13:45:30.000005 -> 00000
“ffffff” The millionths of a second in a date and time value. 2009-06-15T13:45:30.6175420 -> 6175422009-06-15T13:45:30.0000005 -> 000000
“fffffff” The ten millionths of a second in a date and time value. 2009-06-15T13:45:30.6175425 -> 61754252009-06-15T13:45:30.0001150 -> 0001150
“F” If non-zero, the tenths of a second in a date and time value. 2009-06-15T13:45:30.6170000 -> 62009-06-15T13:45:30.0500000 -> (no output)
“FF” If non-zero, the hundredths of a second in a date and time value. 2009-06-15T13:45:30.6170000 -> 612009-06-15T13:45:30.0050000 -> (no output)
“FFF” If non-zero, the milliseconds in a date and time value. 2009-06-15T13:45:30.6170000 -> 6172009-06-15T13:45:30.0005000 -> (no output)
“FFFF” If non-zero, the ten thousandths of a second in a date and time value. 2009-06-15T13:45:30.5275000 -> 52752009-06-15T13:45:30.0000500 -> (no output)
“FFFFF” If non-zero, the hundred thousandths of a second in a date and time value. 2009-06-15T13:45:30.6175400 -> 617542009-06-15T13:45:30.0000050 -> (no output)
“FFFFFF” If non-zero, the millionths of a second in a date and time value. 2009-06-15T13:45:30.6175420 -> 6175422009-06-15T13:45:30.0000005 -> (no output)
“FFFFFFF” If non-zero, the ten millionths of a second in a date and time value. 2009-06-15T13:45:30.6175425 -> 61754252009-06-15T13:45:30.0001150 -> 000115
“g”, “gg” The period or era. 2009-06-15T13:45:30.6170000 -> A.D.
“h” The hour, using a 12-hour clock from 1 to 12. 2009-06-15T01:45:30 -> 12009-06-15T13:45:30 -> 1
“hh” The hour, using a 12-hour clock from 01 to 12. 2009-06-15T01:45:30 -> 012009-06-15T13:45:30 -> 01
“H” The hour, using a 24-hour clock from 0 to 23. 2009-06-15T01:45:30 -> 12009-06-15T13:45:30 -> 13
“HH” The hour, using a 24-hour clock from 00 to 23. 2009-06-15T01:45:30 -> 012009-06-15T13:45:30 -> 13
“K” Time zone information. With DateTime values:2009-06-15T13:45:30, Kind Unspecified ->

2009-06-15T13:45:30, Kind Utc -> Z

2009-06-15T13:45:30, Kind Local -> -07:00 (depends on local computer settings)

With DateTimeOffset values:

2009-06-15T01:45:30-07:00 –> -07:00

2009-06-15T08:45:30+00:00 –> +00:00

“m” The minute, from 0 through 59. 2009-06-15T01:09:30 -> 92009-06-15T13:29:30 -> 29
“mm” The minute, from 00 through 59. 2009-06-15T01:09:30 -> 092009-06-15T01:45:30 -> 45
“M” The month, from 1 through 12. 2009-06-15T13:45:30 -> 6
“MM” The month, from 01 through 12. 2009-06-15T13:45:30 -> 06
“MMM” The abbreviated name of the month. 2009-06-15T13:45:30 -> Jun (en-US)2009-06-15T13:45:30 -> juin (fr-FR)

2009-06-15T13:45:30 -> Jun (zu-ZA)

“MMMM” The full name of the month. 2009-06-15T13:45:30 -> June (en-US)2009-06-15T13:45:30 -> juni (da-DK)

2009-06-15T13:45:30 -> uJuni (zu-ZA)

“s” The second, from 0 through 59. 2009-06-15T13:45:09 -> 9
“ss” The second, from 00 through 59. 2009-06-15T13:45:09 -> 09
“t” The first character of the AM/PM designator. 2009-06-15T13:45:30 -> P (en-US)2009-06-15T13:45:30 -> 午 (ja-JP)

2009-06-15T13:45:30 -> (fr-FR)

“tt” The AM/PM designator. 2009-06-15T13:45:30 -> PM (en-US)
“y” The year, from 0 to 99. 0001-01-01T00:00:00 -> 10900-01-01T00:00:00 -> 0

1900-01-01T00:00:00 -> 0

2009-06-15T13:45:30 -> 9

2019-06-15T13:45:30 -> 19

“yy” The year, from 00 to 99. 0001-01-01T00:00:00 -> 010900-01-01T00:00:00 -> 00

1900-01-01T00:00:00 -> 00

2019-06-15T13:45:30 -> 19

“yyy” The year, with a minimum of three digits. 0001-01-01T00:00:00 -> 0010900-01-01T00:00:00 -> 900

1900-01-01T00:00:00 -> 1900

2009-06-15T13:45:30 -> 2009

“yyyy” The year as a four-digit number. 0001-01-01T00:00:00 -> 00010900-01-01T00:00:00 -> 0900

1900-01-01T00:00:00 -> 1900

2009-06-15T13:45:30 -> 2009

“yyyyy” The year as a five-digit number. 0001-01-01T00:00:00 -> 000012009-06-15T13:45:30 -> 02009
“z” Hours offset from UTC, with no leading zeros. 2009-06-15T13:45:30-07:00 -> -7
“zz” Hours offset from UTC, with a leading zero for a single-digit value. 2009-06-15T13:45:30-07:00 -> -07
“zzz” Hours and minutes offset from UTC. 2009-06-15T13:45:30-07:00 -> -07:00
“:” The time separator. 2009-06-15T13:45:30 -> : (en-US)2009-06-15T13:45:30 -> . (it-IT)

2009-06-15T13:45:30 -> : (ja-JP)

“/” The date separator. 2009-06-15T13:45:30 -> / (en-US)2009-06-15T13:45:30 -> – (ar-DZ)

2009-06-15T13:45:30 -> . (tr-TR)

string“‘string Literal string delimiter. 2009-06-15T13:45:30 (“arr:” h:m t) -> arr: 1:45 P2009-06-15T13:45:30 (‘arr:’ h:m t) -> arr: 1:45 P
% Defines the following character as a custom format specifier. 2009-06-15T13:45:30 (%h) -> 1
\ The escape character. 2009-06-15T13:45:30 (h \h) -> 1 h
Any other character The character is copied to the result string unchanged. 2009-06-15T01:45:30 (arr hh:mm t) -> arr 01:45 A