SQL Date Conversions - More Than You Want To Know

Today I was writing a query that performed some date formatting and found myself using this resource by Manuj Bahl, to which I've often referred but to which I've rarely given any thought. By dumb luck, I fat-fingered one of the codes and ended up with something not listed on the table, but the query ran fine.

Curiousity sufficiently piqued, I wrote a simple Coldfusion script, and a few seconds later found myself looking at a complete table of date/time conversion codes. Most of them are not terribly useful, but in case anyone wants an exhaustive list of every conversion code available, you'll find it behind the cut.

I should note that I use SQL Server 2000, so results may and almost certainly will vary among products/versions.

On an even-less-interesting note, it would appear that the conversion code is restricted to 8 bits, since a value of 256, 512, etc gives the same result as 0, and the same applies to the rest of the list.

The table lists each conversion code and its output given a date/time of March 15, 2008 1:23:45 PM.