DateTimeFormatInfo finfo = new DateTimeFormatInfo();
finfo.ShortDatePattern = "dd/MM/yyyy";
Convert.ToDateTime("31/01/2009", finfo)
1 select convert(varchar, getdate(), 1) 12/30/06
2 select convert(varchar, getdate(), 2) 06.12.30
3 select convert(varchar, getdate(), 3) 30/12/06
4 select convert(varchar, getdate(), 4) 30.12.06
5 select convert(varchar, getdate(), 5) 30-12-06
6 select convert(varchar, getdate(), 6) 30 Dec 06
7 select convert(varchar, getdate(), 7) Dec 30, 06
10 select convert(varchar, getdate(), 10) 12-30-06
11 select convert(varchar, getdate(), 11) 06/12/30
101 select convert(varchar, getdate(), 101) 12/30/2006
102 select convert(varchar, getdate(), 102) 2006.12.30
103 select convert(varchar, getdate(), 103) 30/12/2006
104 select convert(varchar, getdate(), 104) 30.12.2006
105 select convert(varchar, getdate(), 105) 30-12-2006
106 select convert(varchar, getdate(), 106) 30 Dec 2006
107 select convert(varchar, getdate(), 107) Dec 30, 2006
110 select convert(varchar, getdate(), 110) 12-30-2006
111 select convert(varchar, getdate(), 111) 2006/12/30
string a;
Response.Write(string.Format("{0:y yy yyy yyyy}", dt)+"<br/>"); // "8 08 008 2008" year
Response.Write(string.Format("{0:M MM MMM MMMM}", dt)+"<br/>"); // "3 03 Mar March" month
Response.Write(string.Format("{0:d dd ddd dddd}", dt)+"<br/>"); // "9 09 Sun Sunday" day
Response.Write(string.Format("{0:h hh H HH}", dt)+"<br/>"); // "4 04 16 16" hour 12/24
Response.Write(string.Format("{0:m mm}", dt)+"<br/>"); // "5 05" minute
Response.Write(string.Format("{0:s ss}", dt)+"<br/>"); // "7 07" second
Response.Write(string.Format("{0:f ff fff ffff}", dt)+"<br/>"); // "1 12 123 1230" sec.fraction
Response.Write(string.Format("{0:F FF FFF FFFF}", dt)+"<br/>"); // "1 12 123 123" without zeroes
Response.Write(string.Format("{0:t tt}", dt)+"<br/>"); // "P PM" Response.Write(string.M. or P.M.
Response.Write(string.Format("{0:z zz zzz}", dt)+"<br/>"); // "-6 -06 -06:00" time zone
Response.Write(string.Format("{0:t}", dt)+"<br/>"); // "4:05 PM" ShortTime
Response.Write(string.Format("{0:d}", dt)+"<br/>"); // "3/9/2008" ShortDate
Response.Write(string.Format("{0:T}", dt)+"<br/>"); // "4:05:07 PM" LongTime
Response.Write(string.Format("{0:D}", dt)+"<br/>"); // "Sunday, March 09, 2008" LongDate
Response.Write(string.Format("{0:f}", dt)+"<br/>"); // "Sunday, March 09, 2008 4:05 PM" LongDate+ShortTime
Response.Write(string.Format("{0:F}", dt)+"<br/>"); // "Sunday, March 09, 2008 4:05:07 PM" FullDateTime
Response.Write(string.Format("{0:g}", dt)+"<br/>"); // "3/9/2008 4:05 PM" ShortDate+ShortTime
Response.Write(string.Format("{0:G}", dt)+"<br/>"); // "3/9/2008 4:05:07 PM" ShortDate+LongTime
Response.Write(string.Format("{0:m}", dt)+"<br/>"); // "March 09" MonthDay
Response.Write(string.Format("{0:y}", dt)+"<br/>"); // "March, 2008" YearMonth
Response.Write(string.Format("{0:r}", dt)+"<br/>"); // "Sun, 09 Mar 2008 16:05:07 GMT" RFC1123
Response.Write(string.Format("{0:s}", dt)+"<br/>"); // "2008-03-09T16:05:07" SortableDateTime
Response.Write(string.Format("{0:u}", dt)+"<br/>"); // "2008-03-09 16:05:07Z" UniversalSortableDateTime
// month/day numbers without/with leading zeroes
Response.Write(string.Format("{0:M/d/yyyy}", dt)+"<br/>"); // "3/9/2008"
Response.Write(string.Format("{0:MM/dd/yyyy}", dt)+"<br/>"); // "03/09/2008"
// day/month names
Response.Write(string.Format("{0:ddd, MMM d, yyyy}", dt)+"<br/>"); // "Sun, Mar 9, 2008"
Response.Write(string.Format("{0:dddd, MMMM d, yyyy}", dt)+"<br/>"); // "Sunday, March 9, 2008"
Response.Write(string.Format("{0:MMMM dd, yyyy}", dt) + "<br/>");
// two/four digit year
Response.Write(string.Format("{0:MM/dd/yy}", dt)+"<br/>"); // "03/09/08"
Response.Write(string.Format("{0:MM/dd/yyyy}", dt)+"<br/>"); // "03/09/2008"
// date separator in german culture is "." (so "/" changes to ".")
Response.Write(string.Format("{0:d/M/yyyy HH:mm:ss}", dt)+"<br/>");// "9/3/2008 16:05:07" - english (en-US)
Response.Write(string.Format("{0:d/M/yyyy HH:mm:ss}", dt)+"<br/>");// "9.3.2008 16:05:07" - german (de-DE)
//Response.Write(a);