I always forget this SQL syntax, to convert from date to common string formats, so blogging it here once and for all.

-- convert from date to string, with leading zeros, etc.
-- see books online help for "CAST and CONVERT"


-- get leading 0 on a date part
select Right( '00' + CONVERT(VarChar(2),DatePart(mm,getdate())), 2)

-- convert date to a common string format
-- (100 series numbers are with century, 0-99 are with 2 digit year)
SELECT CONVERT(VARCHAR(10), getDate(), 101) -- mm/dd/yyyy (USA)
SELECT CONVERT(VARCHAR(10), getDate(), 112) -- yyyymmdd (ISO)


Posted 11:13 AM    |    0 comments    |    Permalink   

Comparison on many, many facets of Mac OS vs. Windows XP. Everything from networking, files, icons, settings, windows, etc.

Mac OS X vs. Windows XP

Posted 8:57 PM    |    0 comments    |    Permalink   

Windows system tray icon notification for gmail email system.

GMail and GTray

Posted 9:36 PM    |    0 comments    |    Permalink   

Decent traffic site with rollover incident popups.

Shows traffic for SD county, Orange County, bay area, Chicago, etc.

Traffic411: San Diego Traffic Map

Posted 3:40 PM    |    0 comments    |    Permalink   

Digital 3-channel Modulator (Astrotel)

Posted 10:07 AM    |    0 comments    |    Permalink   

Cables To Go: AUDIO/VIDEO MODULATOR - 1 CHANNEL MONO

Posted 10:05 AM    |    0 comments    |    Permalink   

Thanks to Leo at The Screen Savers (before they were closed and he left) for this site.

SnapFiles, has a good set of files, and a search feature that will find only freeware.

keywords: download, freeware, shareware


Posted 7:46 AM    |    0 comments    |    Permalink   

Wow - ATI comes out with a HiDef video card, which is bundled with an antenna and a remote.

Wired News: HD PC: Cheaper Than High-Def TV

Posted 4:17 PM    |    0 comments    |    Permalink   

Wow - a list of many aircraft, by carrier, then a seating chart with comments about various sections.

SeatGuru.com - Your Enlightened Guide to Airplane Seating

Posted 5:46 PM    |    0 comments    |    Permalink   

Leo (from KFI and leoville.com) links to this guy's site with a long list of free software.

Presumably these have been verified spyware-free!

Ramsinks Computers

Posted 3:59 PM    |    0 comments    |    Permalink   

Allows you to record streaming audio from MMS, ASF -- even with a VCR like time-based setting.

freeware

The SDP Multimedia website for ASF download and MMS protocol specification

Posted 3:53 PM    |    0 comments    |    Permalink