DateTime Format

Question

There are various DateTimeFormats

Rahul 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 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 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:. . . . . . . . . -12345.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 Saxena · Answer

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

Rahul 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