Format date [ ] as [ ]

Represents the day of the month as a number from 1 through 31. A single-digit day is formatted without a leading zero

Represents the day of the month as a number from 01 through 31. A single-digit day is formatted with a leading zero

Represents the abbreviated name of the day of the week (Mon, Tues, Wed etc)

Represents the full name of the day of the week (Monday, Tuesday etc)

12-hour clock hour (e.g. 7)

12-hour clock, with a leading 0 (e.g. 07)

24-hour clock hour (e.g. 19)

24-hour clock hour, with a leading 0 (e.g. 19)

Minutes

Minutes with a leading zero

Month number

Month number with leading zero

Abbreviated Month Name (e.g. Dec)

Full month name (e.g. December)

Seconds

Seconds with leading zero

Abbreviated AM / PM (e.g. A or P)

AM / PM (e.g. AM or PM

Year, no leading zero (e.g. 2001 would be 1)

Year, leadin zero (e.g. 2001 would be 01)

Year with minimum of three digits, (e.g. 2001 would be 2001)

Year, (e.g. 2001 would be 2001)

Represents the time zone information of a date and time value (e.g. +05:00)

With DateTime values, represents the signed offset of the local operating system's time zone from Coordinated Universal Time (UTC), measured in hours. (e.g. +6)

As z but with leadin zero (e.g. +06)

With DateTime values, represents the signed offset of the local operating system's time zone from UTC, measured in hours and minutes. (e.g. +06:00)

Represents the most significant digit of the seconds fraction; that is, it represents the tenths of a second in a date and time value.

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.

Represents the three most significant digits of the seconds fraction; that is, it represents the milliseconds in a date and time value.

Represents 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. While 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 Windows NT 3.5 and later, and Windows Vista operating systems, the clock's resolution is approximately 10-15 milliseconds.

Represents 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. While 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 Windows NT 3.5 and later, and Windows Vista operating systems, the clock's resolution is approximately 10-15 milliseconds.

Represents the six most significant digits of the seconds fraction; that is, it represents the millionths of a second in a date and time value. While 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 Windows NT 3.5 and later, and Windows Vista operating systems, the clock's resolution is approximately 10-15 milliseconds.

Represents 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. While 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 Windows NT 3.5 and later, and Windows Vista operating systems, the clock's resolution is approximately 10-15 milliseconds.