Correct Formats for use with ConvertTo.DateTime

The following is a list of Date/Time formats which are usable in conjunction with ConvertTo.DateTime. I found it useful recently, when trying to confirm that the format I was using was "allowed".

The list:


Format 1: 1/13/2006
Format 2: 1/13/06
Format 3: 01/13/06
Format 4: 01/13/2006
Format 5: 06/01/13
Format 6: 2006-01-13
Format 7: 13-Jan-06
Format 8: Friday, January 13, 2006
Format 9: January 13, 2006
Format 10: Friday, 13 January, 2006
Format 11: 13 January, 2006
Format 12: Friday, January 13, 2006 1:21 PM
Format 13: Friday, January 13, 2006 01:21 PM
Format 14: Friday, January 13, 2006 13:21
Format 15: Friday, January 13, 2006 13:21
Format 16: January 13, 2006 1:21 PM
Format 17: January 13, 2006 01:21 PM
Format 18: January 13, 2006 13:21
Format 19: January 13, 2006 13:21
Format 20: Friday, 13 January, 2006 1:21 PM
Format 21: Friday, 13 January, 2006 01:21 PM
Format 22: Friday, 13 January, 2006 13:21
Format 23: Friday, 13 January, 2006 13:21
Format 24: 13 January, 2006 1:21 PM
Format 25: 13 January, 2006 01:21 PM
Format 26: 13 January, 2006 13:21
Format 27: 13 January, 2006 13:21
Format 28: Friday, January 13, 2006 1:21:20 PM
Format 29: Friday, January 13, 2006 01:21:20 PM
Format 30: Friday, January 13, 2006 13:21:20
Format 31: Friday, January 13, 2006 13:21:20
Format 32: January 13, 2006 1:21:20 PM
Format 33: January 13, 2006 01:21:20 PM
Format 34: January 13, 2006 13:21:20
Format 35: January 13, 2006 13:21:20
Format 36: Friday, 13 January, 2006 1:21:20 PM
Format 37: Friday, 13 January, 2006 01:21:20 PM
Format 38: Friday, 13 January, 2006 13:21:20
Format 39: Friday, 13 January, 2006 13:21:20
Format 40: 13 January, 2006 1:21:20 PM
Format 41: 13 January, 2006 01:21:20 PM
Format 42: 13 January, 2006 13:21:20
Format 43: 13 January, 2006 13:21:20
Format 44: 1/13/2006 1:21 PM
Format 45: 1/13/2006 01:21 PM
Format 46: 1/13/2006 13:21
Format 47: 1/13/2006 13:21
Format 48: 1/13/06 1:21 PM
Format 49: 1/13/06 01:21 PM
Format 50: 1/13/06 13:21
Format 51: 1/13/06 13:21
Format 52: 01/13/06 1:21 PM
Format 53: 01/13/06 01:21 PM
Format 54: 01/13/06 13:21
Format 55: 01/13/06 13:21
Format 56: 01/13/2006 1:21 PM
Format 57: 01/13/2006 01:21 PM
Format 58: 01/13/2006 13:21
Format 59: 01/13/2006 13:21
Format 60: 06/01/13 1:21 PM
Format 61: 06/01/13 01:21 PM
Format 62: 06/01/13 13:21
Format 63: 06/01/13 13:21
Format 64: 2006-01-13 1:21 PM
Format 65: 2006-01-13 01:21 PM
Format 66: 2006-01-13 13:21
Format 67: 2006-01-13 13:21
Format 68: 13-Jan-06 1:21 PM
Format 69: 13-Jan-06 01:21 PM
Format 70: 13-Jan-06 13:21
Format 71: 13-Jan-06 13:21
Format 72: 1/13/2006 1:21:20 PM
Format 73: 1/13/2006 01:21:20 PM
Format 74: 1/13/2006 13:21:20
Format 75: 1/13/2006 13:21:20
Format 76: 1/13/06 1:21:20 PM
Format 77: 1/13/06 01:21:20 PM
Format 78: 1/13/06 13:21:20
Format 79: 1/13/06 13:21:20
Format 80: 01/13/06 1:21:20 PM
Format 81: 01/13/06 01:21:20 PM
Format 82: 01/13/06 13:21:20
Format 83: 01/13/06 13:21:20
Format 84: 01/13/2006 1:21:20 PM
Format 85: 01/13/2006 01:21:20 PM
Format 86: 01/13/2006 13:21:20
Format 87: 01/13/2006 13:21:20
Format 88: 06/01/13 1:21:20 PM
Format 89: 06/01/13 01:21:20 PM
Format 90: 06/01/13 13:21:20
Format 91: 06/01/13 13:21:20
Format 92: 2006-01-13 1:21:20 PM
Format 93: 2006-01-13 01:21:20 PM
Format 94: 2006-01-13 13:21:20
Format 95: 2006-01-13 13:21:20
Format 96: 13-Jan-06 1:21:20 PM
Format 97: 13-Jan-06 01:21:20 PM
Format 98: 13-Jan-06 13:21:20
Format 99: 13-Jan-06 13:21:20
Format 100: January 13
Format 101: January 13
Format 102: 2006-01-13T13:21:20.0156250-05:00
Format 103: 2006-01-13T13:21:20.0156250-05:00
Format 104: Fri, 13 Jan 2006 13:21:20 GMT
Format 105: Fri, 13 Jan 2006 13:21:20 GMT
Format 106: 2006-01-13T13:21:20
Format 107: 1:21 PM
Format 108: 01:21 PM
Format 109: 13:21
Format 110: 13:21
Format 111: 1:21:20 PM
Format 112: 01:21:20 PM
Format 113: 13:21:20
Format 114: 13:21:20
Format 115: 2006-01-13 13:21:20Z
Format 116: Friday, January 13, 2006 6:21:20 PM
Format 117: Friday, January 13, 2006 06:21:20 PM
Format 118: Friday, January 13, 2006 18:21:20
Format 119: Friday, January 13, 2006 18:21:20
Format 120: January 13, 2006 6:21:20 PM
Format 121: January 13, 2006 06:21:20 PM
Format 122: January 13, 2006 18:21:20
Format 123: January 13, 2006 18:21:20
Format 124: Friday, 13 January, 2006 6:21:20 PM
Format 125: Friday, 13 January, 2006 06:21:20 PM
Format 126: Friday, 13 January, 2006 18:21:20
Format 127: Friday, 13 January, 2006 18:21:20
Format 128: 13 January, 2006 6:21:20 PM
Format 129: 13 January, 2006 06:21:20 PM
Format 130: 13 January, 2006 18:21:20
Format 131: 13 January, 2006 18:21:20
Format 132: January, 2006
Format 133: January, 2006

 Print | Posted on Wednesday, October 25, 2006 3:48 PM |



Feedback

No comments posted yet.


Post Comment

Title  
Name  
Email
Website / Url
 

Your comment

   
Ensure the word in this box says 'orange':
 
Please add 1 and 2 and type the answer here:





Due to excessive comment spam, all comments are now being moderated. If you're a comment spammer then you're wasting your time here. Your comments will not be published - ever.


About me

My name is Ross Hawkins and I'm a developer, consultant, business owner and writer based in Auckland, New Zealand (pictured below!). My current work revolves around ASP.NET, C#, jQuery, Ajax, SQL Server, and a mix of other Microsoft development technologies.

I also have about 15 years of experience with IBM Lotus Notes/Domino and associated technologies. While Notes/Domino is no longer my primary focus I still like to dabble and keep my skills up to date.

I own and run 2 businesses - Hawkins Consulting Services, and Ignition Development.

Bethells Beach, located in sunny West Auckland, New Zealand




Subscribe

Subscribe to this feed


Search




Popular Content

Troubleshooting WebResource.axd

The .NET 2.0 framework changed the way clientside JavaScript is delivered to the browser. Previously, ASP.NET 1.1 used the aspnet_client directory whereas now 2.0 uses WebResource.axd.

Published on October 8, 2006

jQuery Wildcard Selectors - some simple examples

I wrote about jQuery wildcard selector syntax briefly back in 2009, and since then that post has received a lot of views – way more than a post that brief should ever have seen..

Published on October 14, 2011

Microsoft AJAX Extensions: Sys.Debug is null or not an object

One of the breaking changes which was made with the 1.0 release of the Microsoft Ajax Extensions was the renaming of the 'Debug' class to 'Sys.Debug' for reasons of compatiability with other frameworks. Breaking changes like this can often be a source of frustration..

Published on May 22, 2007

Simple ASP.NET Character Counter

A textbox character counter is a pretty simple piece of functionality, and there's a lot of different ways to apply one to your application. The following method is nice and simple, and can be done using only clientside JavaScript if required, or combined with server side code in order to create a more dynamic effect

Published on December 4, 2006

Simple ASP.NET Character Counter - with Master Page Support

A quick update to my previous character counter article adding some changes for those using it with Master Pages.

Published on February 7th, 2009

Adding Tooltips to Gridview Headers

As the title says, this is a very simple but dynamic way of achieving tooltip text on a header column. It's not overly flash, but it's lightweight and quick to implement.

Published on April 15, 2007

SQL Server Web Report Viewer Issues on Windows 2008 Server/IIS7

A fix for another AXD related issue, this time with the SQL Server Web Report Viewer Control which was being served up via IIS7 on a Windows 2008 server.

Published on June 2, 2007
Updated on April 10, 2008





Archives

May, 2012 (1)
April, 2012 (4)
March, 2012 (2)
February, 2012 (4)
January, 2012 (3)
December, 2011 (3)
November, 2011 (8)
October, 2011 (9)
September, 2011 (8)
August, 2011 (5)
July, 2011 (4)
June, 2011 (7)
May, 2011 (5)
April, 2011 (3)
March, 2011 (8)
February, 2011 (4)
January, 2011 (3)
December, 2010 (8)
November, 2010 (5)
October, 2010 (6)
September, 2010 (7)
August, 2010 (11)
July, 2010 (12)
June, 2010 (8)
May, 2010 (8)
April, 2010 (4)
March, 2010 (8)
February, 2010 (6)
January, 2010 (12)
December, 2009 (13)
November, 2009 (11)
October, 2009 (12)
September, 2009 (12)
August, 2009 (2)
July, 2009 (7)
June, 2009 (12)
May, 2009 (9)
April, 2009 (9)
March, 2009 (9)
February, 2009 (8)
January, 2009 (7)
December, 2008 (6)
November, 2008 (7)
October, 2008 (9)
September, 2008 (12)
August, 2008 (9)
July, 2008 (6)
June, 2008 (24)
May, 2008 (13)
April, 2008 (16)
March, 2008 (8)
February, 2008 (10)
January, 2008 (1)
December, 2007 (14)
November, 2007 (11)
October, 2007 (11)
September, 2007 (13)
August, 2007 (11)
July, 2007 (5)
June, 2007 (15)
May, 2007 (11)
April, 2007 (9)
March, 2007 (9)
February, 2007 (10)
January, 2007 (8)
December, 2006 (18)
November, 2006 (11)
October, 2006 (14)
September, 2006 (9)
August, 2006 (10)
July, 2006 (4)
June, 2006 (4)
May, 2006 (6)
April, 2006 (3)
February, 2006 (6)
January, 2006 (10)
September, 2005 (2)
August, 2005 (4)

Post Categories

ASP.NET
AJAX
Amusing
NZ
NZ Trains
Notes/Domino
Visual Studio
Web Development
Miscellaneous
Me
Rugby
C#
SQL