The "d" format code represents the day of the month as a number from 1 through 31. A single-digit day is formatted without a leading zero.

If the "d" Format code is used without other format codes, it is interpreted as the "d" standard date and time Format code.

Back to table

The "dd" format codes represent the day of the month as a number from 01 through 31. A single-digit day is formatted with a leading zero.

The following example includes the "dd" format code in a format codes.

Back to table

The "ddd" format codes represent the abbreviated name of the day of the week.

Back to table

The "dddd" format codes (plus any number of additional "d" Codes) represents the full name of the day of the week.

Back to table

The "f" format code represents the most significant digit of the seconds fraction; that is, it represents the tenths of a second in a date and time value.

When you use "f" format code the number of "f" format codes indicates the number of most significant digits of the seconds fraction that must be present to successfully parse the string.

Back to table

The "ff" format code represents the two most significant digits of the seconds fraction; that is, it represents the hundredths of a second in a date and time value.

Back to table

The "fff" format codes represent the three most significant digits of the seconds fraction; that is, it represents the milliseconds in a date and time value.

Back to table

The "ffff" format codes represent the four most significant digits of the seconds fraction; that is, it represents the ten thousandths of a second in a date and time value.

Although it is possible to display the ten thousandths of a second component of a time value, that value may not be meaningful. The precision of date and time values depends on the resolution of the system clock. On the Windows NT version 3.5 (and later) and Windows Vista operating systems, the clock's resolution is approximately 10-15 milliseconds.

Back to table

The "fffff" format codes represent the five most significant digits of the seconds fraction; that is, it represents the hundred thousandths of a second in a date and time value.

Although it is possible to display the hundred thousandths of a second component of a time value, that value may not be meaningful. The precision of date and time values depends on the resolution of the system clock. On the Windows NT 3.5 (and later) and Windows Vista operating systems, the clock's resolution is approximately 10-15 milliseconds.

Back to table

The "ffffff" format codes represent the six most significant digits of the seconds fraction; that is, it represents the millionths of a second in a date and time value.

Although it is possible to display the millionths of a second component of a time value, that value may not be meaningful. The precision of date and time values depends on the resolution of the system clock. On the Windows NT 3.5 (and later) and Windows Vista operating systems, the clock's resolution is approximately 10-15 milliseconds.

Back to table

The "fffffff" format codes represent the seven most significant digits of the seconds fraction; that is, it represents the ten millionths of a second in a date and time value.

Although it is possible to display the ten millionths of a second component of a time value, that value may not be meaningful. The precision of date and time values depends on the resolution of the system clock. On the Windows NT 3.5 (and later) and Windows Vista operating systems, the clock's resolution is approximately 10-15 milliseconds.

Back to table

The "F" format code represents the most significant digit of the seconds fraction; that is, it represents the tenths of a second in a date and time value. Nothing is displayed if the digit is zero.

If the "F" format code is used without other format codes, it is interpreted as the "F" standard date and time Format code.

Back to table

The "FF" format code represents the two most significant digits of the seconds fraction; that is, it represents the hundredths of a second in a date and time value. However, trailing zeros or two zero digits are not displayed.

Back to table

The "FFF" format codes represent the three most significant digits of the seconds fraction; that is, it represents the milliseconds in a date and time value. However, trailing zeros or three zero digits are not displayed.

Back to table

The "FFFF" format codes represent the four most significant digits of the seconds fraction; that is, it represents the ten thousandths of a second in a date and time value. However, trailing zeros or four zero digits are not displayed.

Although it is possible to display the ten thousandths of a second component of a time value, that value may not be meaningful. The precision of date and time values depends on the resolution of the system clock. On the Windows NT 3.5 (and later) and Windows Vista operating systems, the clock's resolution is approximately 10-15 milliseconds.

Back to table

The "FFFFF" format codes represent the five most significant digits of the seconds fraction; that is, it represents the hundred thousandths of a second in a date and time value. However, trailing zeros or five zero digits are not displayed.

Although it is possible to display the hundred thousandths of a second component of a time value, that value may not be meaningful. The precision of date and time values depends on the resolution of the system clock. On the Windows NT 3.5 (and later) and Windows Vista operating systems, the clock's resolution is approximately 10-15 milliseconds.

Back to table

The "FFFFFF" format codes represent the six most significant digits of the seconds fraction; that is, it represents the millionths of a second in a date and time value. However, trailing zeros or six zero digits are not displayed.

Although it is possible to display the millionths of a second component of a time value, that value may not be meaningful. The precision of date and time values depends on the resolution of the system clock. On the Windows NT 3.5 (and later) and Windows Vista operating systems, the clock's resolution is approximately 10-15 milliseconds.

Back to table

The "FFFFFFF" format codes represent the seven most significant digits of the seconds fraction; that is, it represents the ten millionths of a second in a date and time value. However, trailing zeros or seven zero digits are not displayed.

Although it is possible to display the ten millionths of a second component of a time value, that value may not be meaningful. The precision of date and time values depends on the resolution of the system clock. On the Windows NT 3.5 (and later) and Windows Vista operating systems, the clock's resolution is approximately 10-15 milliseconds.

Back to table

The "g" or "gg" format codes (plus any number of additional "g" Codes) represents the period or era, such as A.D. The formatting operation ignores this code if the date to be formatted does not have an associated period or era string.

If the "g" Format code is used without other format codes, it is interpreted as the "g" standard date and time Format code.

Back to table

The "h" format code represents the hour as a number from 1 through 12; that is, the hour is represented by a 12-hour clock that counts the whole hours since midnight or noon. A particular hour after midnight is indistinguishable from the same hour after noon. The hour is not rounded, and a single-digit hour is formatted without a leading zero. For example, given a time of 5:43 in the morning or afternoon, this format codes displays "5".

Back to table

The "hh" format code (plus any number of additional "h" Codes) represents the hour as a number from 01 through 12; that is, the hour is represented by a 12-hour clock that counts the whole hours since midnight or noon. A particular hour after midnight is indistinguishable from the same hour after noon. The hour is not rounded, and a single-digit hour is formatted with a leading zero. For example, given a time of 5:43 in the morning or afternoon, this Format code displays "05".

Back to table

The "H" format code represents the hour as a number from 0 through 23; that is, the hour is represented by a zero-based 24-hour clock that counts the hours since midnight. A single-digit hour is formatted without a leading zero.

Back to table

The "HH" format code (plus any number of additional "H" Codes) represents the hour as a number from 00 through 23; that is, the hour is represented by a zero-based 24-hour clock that counts the hours since midnight. A single-digit hour is formatted with a leading zero.

Back to table

The "K" format code represents the time zone information of a date and time value.

Back to table

The "m" format code represents the minute as a number from 0 through 59. The minute represents whole minutes that have passed since the last hour. A single-digit minute is formatted without a leading zero.

Back to table

The "mm" format code (plus any number of additional "m" Codes) represents the minute as a number from 00 through 59. The minute represents whole minutes that have passed since the last hour. A single-digit minute is formatted with a leading zero.

Back to table

The "M" format code represents the month as a number from 1 through 12 (or from 1 through 13 for calendars that have 13 months). A single-digit month is formatted without a leading zero.

Back to table

The "MM" format code represents the month as a number from 01 through 12 (or from 1 through 13 for calendars that have 13 months). A single-digit month is formatted with a leading zero.

Back to table

The "MMM" format codes represent the abbreviated name of the month.

Back to table

The "MMMM" format codes represent the full name of the month.

Back to table

The "s" format code represents the seconds as a number from 0 through 59. The result represents whole seconds that have passed since the last minute. A single-digit second is formatted without a leading zero.

Back to table

The "ss" format code (plus any number of additional "s" Codes) represents the seconds as a number from 00 through 59. The result represents whole seconds that have passed since the last minute. A single-digit second is formatted with a leading zero.

Back to table

The "t" format code represents the first character of the AM/PM designator. The AM designator is used for all times from 0:00:00 (midnight) to 11:59:59.999. The PM designator is used for all times from 12:00:00 (noon) to 23:59:59.99.

Back to table

The "tt" format code (plus any number of additional "t" Codes) represents the entire AM/PM designator. The AM designator is used for all times from 0:00:00 (midnight) to 11:59:59.999. The PM designator is used for all times from 12:00:00 (noon) to 23:59:59.99.

Back to table

The "y" format code represents the year as a one-digit or two-digit number. If the year has more than two digits, only the two low-order digits appear in the result. If the first digit of a two-digit year begins with a zero (for example, 2008), the number is formatted without a leading zero.

Back to table

The "yy" format code represents the year as a two-digit number. If the year has more than two digits, only the two low-order digits appear in the result. If the two-digit year has fewer than two significant digits, the number is padded with leading zeros to produce two digits.

Back to table

The "yyy" format codes represent the year with a minimum of three digits. If the year has more than three significant digits, they are included in the result string. If the year has fewer than three digits, the number is padded with leading zeros to produce three digits.

Back to table

The "yyyy" format codes represent the year with a minimum of four digits. If the year has more than four significant digits, they are included in the result string. If the year has fewer than four digits, the number is padded with leading zeros to produce four digits.

Back to table

The "yyyyy" format codes (plus any number of additional "y" Codes) represents the year with a minimum of five digits. If the year has more than five significant digits, they are included in the result string. If the year has fewer than five digits, the number is padded with leading zeros to produce five digits.

If there are additional "y" Codes, the number is padded with as many leading zeros as necessary to produce the number of "y" Codes.

Back to table

The "z" format code represents the signed offset of the local operating system's time zone from Coordinated Universal Time (UTC), measured in hours.

The offset is always displayed with a leading sign. A plus sign (+) indicates hours ahead of UTC, and a minus sign (-) indicates hours behind UTC. A single-digit offset is formatted without a leading zero.

Back to table

The "zz" format code represents the signed offset of the local operating system's time zone from UTC, measured in hours.

The offset is always displayed with a leading sign. A plus sign (+) indicates hours ahead of UTC, and a minus sign (-) indicates hours behind UTC. A single-digit offset is formatted with a leading zero.

Back to table

The "zzz" format code represents the signed offset of the local operating system's time zone from UTC, measured in hours and minutes.

The offset is always displayed with a leading sign. A plus sign (+) indicates hours ahead of UTC, and a minus sign (-) indicates hours behind UTC. A single-digit offset is formatted with a leading zero.

Back to table

The ":" format code represents the time separator, which is used to differentiate hours, minutes, and seconds.

Back to table

The "/", "-" and "." format codes represent a date separator, which is used to differentiate years, months, and days.

Back to table