Sql Date Time formats.


century (yy)
standard outputformat
0 or 100 (*) default mon dd yyyy hh:miAM (or PM)
1 101 USA mm/dd/yy
2 102 ANSI yy.mm.dd
3 103 British/French dd/mm/yy
4 104 German dd.mm.yy
5 105 Italian dd-mm-yy
6 106 dd mon yy
7 107 mon dd, yy
8 108 hh:mm:ss
9 or 109 (*) default
mon dd yyyy hh:mi:ss:mmmAM (or PM)
10 110 USA mm-dd-yy
11 111 Japan yy/mm/dd
12 112 ISO yymmdd
13 or 113 (*) Europe default
dd mon yyyy hh:mm:ss:mmm(24h)
14 114 hh:mi:ss:mmm(24h)
20 120 yyyy-mm-dd hh:mi:ss(24h)
21 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

(*) the default values (style 0 or 100, 9 or 109, and
13 or 113) always return the century (yyyy)

Hot Stuff

Kashmir Dum Aloo by Ashoka.

This is described as “Curried potatoes in medium hot sauce.” “Medium” is definitely an Indian palate relative rating, because this is definitely near the “hot” scale for me, and I love spicy Thai and Indian food.

Run Command Most Recently Used List Storage

At least for Windows XP, this list is stored in the registry:

My ComputerHKEY_CURRENT_USERSoftwareMicrosoftWindowsCurrentVersionExplorerRunMRU

It looks like there are values a through z off of RunMRU, plus (Default) and MRUList. There is string value in MRUList: e.g., “nkvlsawbhczeyoijfugrtdxpmq”, which determines the ordering of MRUList entries.

Thai and Indian Meals

Pad Thai, Curry, and Pad Grapow Mix

Pad Thai

Palak Paneer

Dal Makhani

Miscellaneous Excel tricks that I needed today.

How to hide gridlines on an Excel Worksheet.

Select a Worksheet.
Select Tools->Options…
On the [View] tab, un-check Gridlines under the Window Options section.

Row and column headers, scroll bars, and sheet tabs are also hideable through this tab.

How to Split and Freeze Panes

Freeze panes makes very nice title rows (the bottom pane does not scroll into the title row).

ILASM and ILDASM (.NET “Assembler”)

Reverse Engineering To Learn .NET Better

Accessible via command line using:
Start->Microsoft Visual Studio 2005->Visual Studio Tools->Visual Studio 2005 Command Prompt

Buffalo Wild Wings calorie equivalents?

I’ve been searching extensively for Buffalo Wild Wings calorie content on the web, and have heard of many responses that they don’t provide content because of their extensive menu.


Well, here is at least one “similar” option for the wings:
WingStreet’s (Pizza Hut) Nutrition Guide