Both are good examples of some scripts.  Does anyone have an addition to the UDF_CONVERTDATE that would add option 7 that would allow returning just the time?  Maybe 7 would return "1:30 PM" and 8 would return "13:30".  Just thought I'd ask before trying to add it myself.

Does SQL 2005 have some of this built in?