Time Patterns

Pattern Variables

d Represents the day of the month as a number from 1 through 31. No leading zero
dd Represents the day of the month as a number from 01 through 31. A single-digit day is formatted with a leading zero
ddd Represents the abbreviated name of the day of the week (Mon, Tues, Wed etc)
dddd Represents the full name of the day of the week (Monday, Tuesday etc)
h hour clock hour (e.g. 7)
hh hour clock, with a leading 0 (e.g. 07)
H 24-hour clock hour (e.g. 19)
HH 24-hour clock hour, with a leading 0 (e.g. 07)
m Minutes
mm Minutes with a leading zero
M Month number
MM Month number with leading zero
MMM Abbreviated Month Name (e.g. Dec)
MMMM Full month name (e.g. December)
s Seconds
ss Seconds with leading zero
t Abbreviated AM / PM (e.g. A or P)
tt AM/PM (e.g. AM or PM)
y Year, no leading zero (e.g. 2001 would be 1)
yy Year, leadin zero (e.g. 2001 would be 01)
yyy Year, (e.g. 2001 would be 2001)
yyyy Year, (e.g. 2001 would be 2001)
K Represents the time zone information of a date and time value (e.g. +05:00)
z 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)
zz As z but with leadin zero (e.g. +06)
zzz 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)
f Represents the most significant digit of the seconds fraction;
that is, it represents the tenths of a second in a date and time value.
ff 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.
fff Represents the three most significant digits of the seconds fraction;
that is, it represents the milliseconds in a date and time value.
ffff 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.
fffff 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.
ffffff 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.
fffffff 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.

Pattern Examples

Format String Output
MM/dd/yyyy 08/22/2006
 dddd, dd MMMM yyyy Tuesday, 22 August 2006
dddd, dd MMMM yyyy HH:mm Tuesday, 22 August 2006 06:30
 dddd, dd MMMM yyyy hh:mm tt Tuesday, 22 August 2006 06:30 AM
dddd, dd MMMM yyyy H:mm Tuesday, 22 August 2006 6:30
 dddd, dd MMMM yyyy h:mm tt Tuesday, 22 August 2006 6:30 AM
dddd, dd MMMM yyyy HH:mm:ss Tuesday, 22 August 2006 06:30:07
MM/dd/yyyy HH:mm 08/22/2006 06:30
MM/dd/yyyy hh:mm tt 08/22/2006 06:30 AM
 MM/dd/yyyy H:mm 08/22/2006 6:30
MM/dd/yyyy h:mm tt 08/22/2006 6:30 AM
MM/dd/yyyy h:mm tt 08/22/2006 6:30 AM
 MM/dd/yyyy h:mm tt 08/22/2006 6:30 AM
MM/dd/yyyy HH:mm:ss 08/22/2006 06:30:07
MMMM dd August 22
MMMM dd August 22
 yyyyMMddTHH:mm:ss.fffffffK 20060822T06:30:07.719922204:00
 yyyyMMddTHH:mm:ss.fffffffK 20060822T06:30:07.719922204:00
ddd, dd MMM yyyy HH:mm:ss GMT Tue, 22 Aug 2006 06:30:07 GMT
ddd, dd MMM yyyy HH:mm:ss GMT Tue, 22 Aug 2006 06:30:07 GMT
yyyyMMddTHH:mm:ss 20060822T06:30:07
HH:mm 06:30
hh:mm tt 06:30 AM
H:mm 6:30
h:mm tt 6:30 AM
HH:mm:ss 06:30:07
yyyyMMdd HH:mm:ssZ 20060822 06:30:07Z
dddd, dd MMMM yyyy HH:mm:ss Tuesday, 22 August 2006 06:30:07
yyyy MMMM 2006 August
yyyy MMMM 2006 August