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)

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.

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).

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