Correct Formats for use with ConvertTo.DateTime

<< IE7 Automatic Deployment | Home | Firefox 2.0 Released >>

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 |

Like this?
Share it!

Feedback

No comments posted yet.

Post Comment

Title
Name
Email
Website / Url

Your comment
Remember Me?
Ensure the word in this box says 'orange':
Please add 1 and 6 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