DateTime Format

Question

There are various DateTimeFormats

Rahul Kumar Saxena · Answer

Some DateTime Conversion in SP Style ID Style Type 0 or 100 mon dd yyyy hh:miAM (or PM) 101 mm/dd/yy 102 yy.mm.dd 103 dd/mm/yy 104 dd.mm.yy 105 dd-mm-yy 106 dd mon yy 107 Mon dd, yy 108 hh:mm:ss 9 or 109 mon dd yyyy hh:mi:ss:mmmAM (or PM) 110 mm-dd-yy 111 yy/mm/dd 112 yymmdd 13 or 113 dd mon yyyy hh:mm:ss:mmm(24h) 114 hh:mi:ss:mmm(24h) 20 or 120 yyyy-mm-dd hh:mi:ss(24h) 21 or 121 yyyy-mm-dd hh:mi:ss.mmm(24h) 126 yyyy-mm-dd Thh:mm:ss.mmm(no spaces) 130 dd mon yyyy hh:mi:ss:mmmAM 131 dd/mm/yy hh:mi:ss:mmmAM

Vijaya Kadiyala · Answer

Hi, good information. If you post this as article then it would be useful rather posting several times in the forum. Thanks -- Vj

Rahul Kumar Saxena · Answer

All the Patterns: 0 MM/dd/yyyy 04/23/2008 1 dddd, dd MMMM yyyy Wednesday, 23 April 2008 2 dddd, dd MMMM yyyy HH:mm Wednesday, 23 April 2008 02:46 3 dddd, dd MMMM yyyy hh:mm tt Wednesday, 23 April 2008 02:46 AM 4 dddd, dd MMMM yyyy H:mm Wednesday, 23 April 2008 2:46 5 dddd, dd MMMM yyyy h:mm tt Wednesday, 23 April 2008 2:46 AM 6 dddd, dd MMMM yyyy HH:mm:ss Wednesday, 23 April 2008 02:46:33 7 MM/dd/yyyy HH:mm 04/23/2008 02:46 8 MM/dd/yyyy hh:mm tt 04/23/2008 02:46 AM 9 MM/dd/yyyy H:mm 04/23/2008 2:46 10 MM/dd/yyyy h:mm tt 04/23/2008 2:46 AM 11 MM/dd/yyyy HH:mm:ss 04/23/2008 02:46:33 12 MMMM dd April 23 13 MMMM dd April 23 14 yyyy'-'MM'-'dd'T'HH':'mm':'ss.fffffffK 2008-04-23T02:46:33.4176674-04:00 15 yyyy'-'MM'-'dd'T'HH':'mm':'ss.fffffffK 2008-04-23T02:46:33.4176674-04:00 16 ddd, dd MMM yyyy HH':'mm':'ss 'GMT' Wed, 23 Apr 2008 02:46:33 GMT 17 ddd, dd MMM yyyy HH':'mm':'ss 'GMT' Wed, 23 Apr 2008 02:46:33 GMT 18 yyyy'-'MM'-'dd'T'HH':'mm':'ss 2008-04-23T02:46:33 19 HH:mm 02:46 20 hh:mm tt 02:46 AM 21 H:mm 2:46 22 h:mm tt 2:46 AM 23 HH:mm:ss 02:46:33 24 yyyy'-'MM'-'dd HH':'mm':'ss'Z' 2008-04-23 02:46:33Z 25 dddd, dd MMMM yyyy HH:mm:ss Wednesday, 23 April 2008 02:46:33 26 yyyy MMMM 2008 April 27 yyyy MMMM 2008 April The patterns for DateTime.ToString ( 'd' ) : 0 MM/dd/yyyy 04/23/2008 The patterns for DateTime.ToString ( 'D' ) : 0 dddd, dd MMMM yyyy Wednesday, 23 April 2008 The patterns for DateTime.ToString ( 'f' ) : 0 dddd, dd MMMM yyyy HH:mm Wednesday, 23 April 2008 02:46 1 dddd, dd MMMM yyyy hh:mm tt Wednesday, 23 April 2008 02:46 AM 2 dddd, dd MMMM yyyy H:mm Wednesday, 23 April 2008 2:46 3 dddd, dd MMMM yyyy h:mm tt Wednesday, 23 April 2008 2:46 AM The patterns for DateTime.ToString ( 'F' ) : 0 dddd, dd MMMM yyyy HH:mm:ss Wednesday, 23 April 2008 02:46:33 The patterns for DateTime.ToString ( 'g' ) : 0 MM/dd/yyyy HH:mm 04/23/2008 02:46 1 MM/dd/yyyy hh:mm tt 04/23/2008 02:46 AM 2 MM/dd/yyyy H:mm 04/23/2008 2:46 3 MM/dd/yyyy h:mm tt 04/23/2008 2:46 AM The patterns for DateTime.ToString ( 'G' ) : 0 MM/dd/yyyy HH:mm:ss 04/23/2008 02:46:33 The patterns for DateTime.ToString ( 'm' ) : 0 MMMM dd April 23 The patterns for DateTime.ToString ( 'r' ) : 0 ddd, dd MMM yyyy HH':'mm':'ss 'GMT' Wed, 23 Apr 2008 02:46:33 GMT The patterns for DateTime.ToString ( 's' ) : 0 yyyy'-'MM'-'dd'T'HH':'mm':'ss 2008-04-23T02:46:33 The patterns for DateTime.ToString ( 'u' ) : 0 yyyy'-'MM'-'dd HH':'mm':'ss'Z' 2008-04-23 02:46:33Z The patterns for DateTime.ToString ( 'U' ) : 0 dddd, dd MMMM yyyy HH:mm:ss Wednesday, 23 April 2008 02:46:33 The patterns for DateTime.ToString ( 'y' ) : 0 yyyy MMMM 2008 April

Rahul Kumar Saxena · Answer

DateTime Formatting in ASP.NET 2.0 using System; class Sample { enum Color {Yellow = 1, Blue, Green}; static DateTime thisDate = DateTime.Now; public static void Main() { string s = "" ; Console.Clear(); // Format a negative integer or floating-point number in various ways. Console.WriteLine( "Standard Numeric Format Specifiers" ); s = String.Format( "(C) Currency: . . . . . . . . {0:C}
" + "(D) Decimal:. . . . . . . . . {0:D}
" + "(E) Scientific: . . . . . . . {1:E}
" + "(F) Fixed point:. . . . . . . {1:F}
" + "(G) General:. . . . . . . . . {0:G}
" + " (default):. . . . . . . . {0} (default = 'G')
" + "(N) Number: . . . . . . . . . {0:N}
" + "(P) Percent:. . . . . . . . . {1:P}
" + "(R) Round-trip: . . . . . . . {1:R}
" + "(X) Hexadecimal:. . . . . . . {0:X}
" , - 123, - 123.45f); Console.WriteLine(s); // Format the current date in various ways. Console.WriteLine( "Standard DateTime Format Specifiers" ); s = String.Format( "(d) Short date: . . . . . . . {0:d}
" + "(D) Long date:. . . . . . . . {0:D}
" + "(t) Short time: . . . . . . . {0:t}
" + "(T) Long time:. . . . . . . . {0:T}
" + "(f) Full date/short time: . . {0:f}
" + "(F) Full date/long time:. . . {0:F}
" + "(g) General date/short time:. {0:g}
" + "(G) General date/long time: . {0:G}
" + " (default):. . . . . . . . {0} (default = 'G')
" + "(M) Month:. . . . . . . . . . {0:M}
" + "(R) RFC1123:. . . . . . . . . {0:R}
" + "(s) Sortable: . . . . . . . . {0:s}
" + "(u) Universal sortable: . . . {0:u} (invariant)
" + "(U) Universal sortable: . . . {0:U}
" + "(Y) Year: . . . . . . . . . . {0:Y}
" , thisDate); Console.WriteLine(s); // Format a Color enumeration value in various ways. Console.WriteLine( "Standard Enumeration Format Specifiers" ); s = String.Format( "(G) General:. . . . . . . . . {0:G}
" + " (default):. . . . . . . . {0} (default = 'G')
" + "(F) Flags:. . . . . . . . . . {0:F} (flags or integer)
" + "(D) Decimal number: . . . . . {0:D}
" + "(X) Hexadecimal:. . . . . . . {0:X}
" , Color.Green); Console.WriteLine(s); } } /* This code example produces the following results: Standard Numeric Format Specifiers (C) Currency: . . . . . . . . ($123.00) (D) Decimal:. . . . . . . . . -123 (E) Scientific: . . . . . . . -1.234500E+002 (F) Fixed point:. . . . . . . -123.45 (G) General:. . . . . . . . . -123 (default):. . . . . . . . -123 (default = 'G') (N) Number: . . . . . . . . . -123.00 (P) Percent:. . . . . . . . . -12,345.00 % (R) Round-trip: . . . . . . . -123.45 (X) Hexadecimal:. . . . . . . FFFFFF85 Standard DateTime Format Specifiers (d) Short date: . . . . . . . 6/26/2004 (D) Long date:. . . . . . . . Saturday, June 26, 2004 (t) Short time: . . . . . . . 8:11 PM (T) Long time:. . . . . . . . 8:11:04 PM (f) Full date/short time: . . Saturday, June 26, 2004 8:11 PM (F) Full date/long time:. . . Saturday, June 26, 2004 8:11:04 PM (g) General date/short time:. 6/26/2004 8:11 PM (G) General date/long time: . 6/26/2004 8:11:04 PM (default):. . . . . . . . 6/26/2004 8:11:04 PM (default = 'G') (M) Month:. . . . . . . . . . June 26 (R) RFC1123:. . . . . . . . . Sat, 26 Jun 2004 20:11:04 GMT (s) Sortable: . . . . . . . . 2004-06-26T20:11:04 (u) Universal sortable: . . . 2004-06-26 20:11:04Z (invariant) (U) Universal sortable: . . . Sunday, June 27, 2004 3:11:04 AM (Y) Year: . . . . . . . . . . June, 2004 Standard Enumeration Format Specifiers (G) General:. . . . . . . . . Green (default):. . . . . . . . Green (default = 'G') (F) Flags:. . . . . . . . . . Green (flags or integer) (D) Decimal number: . . . . . 3 (X) Hexadecimal:. . . . . . . 00000003 */

Rahul Kumar Saxena · Answer

Parsing Date At ASPX page # DateTime .Parse(Eval( "DateColumnName" ).ToString()).ToString( "MMM dd, yyyy" )%>

Rahul Kumar Saxena · Answer

DateTime.Now; 4/19/2008 7:04:34 AM DateTime.Now.ToString(); 4/19/2008 7:04:34 AM DateTime.Now.ToShortTimeString() 7:04 AM DateTime.Now.ToShortDateString() 4/19/2008 DateTime.Now.ToLongTimeString() 7:04:34 AM DateTime.Now.ToLongDateString() Saturday, April 19, 2008 DateTime.Now.ToString("d") 4/19/2008 DateTime.Now.ToString("D") Saturday, April 19, 2008 DateTime.Now.ToString("f") Saturday, April 19, 2008 7:04 AM DateTime.Now.ToString("F") Saturday, April 19, 2008 7:04:34 AM DateTime.Now.ToString("g") 4/19/2008 7:04 AM DateTime.Now.ToString("G") 4/19/2008 7:04:34 AM DateTime.Now.ToString("m") April 19 DateTime.Now.ToString("r") Sat, 19 Apr 2008 07:04:34 GMT DateTime.Now.ToString("s") 2008-04-19T07:04:34 DateTime.Now.ToString("t") 7:04 AM DateTime.Now.ToString("T") 7:04:34 AM DateTime.Now.ToString("u") 2008-04-19 07:04:34Z DateTime.Now.ToString("U") Saturday, April 19, 2008 12:04:34 PM DateTime.Now.ToString("y") April, 2008 DateTime.Now.ToString("dddd, MMMM dd yyyy") Saturday, April 19 2008 DateTime.Now.ToString("ddd, MMM d "'"yy") Sat, Apr 19 '08 DateTime.Now.ToString("dddd, MMMM dd") Saturday, April 19 DateTime.Now.ToString("M/yy") 4/08 DateTime.Now.ToString("dd-MM-yy") 19-04-08