Listing 1: Sample T-SQL Query (goes with Tip 1)
DECLARE @Testdate datetime
SET @Testdate = '2003-09-24'
SELECT
	CASE LEN(DATEPART(m,@Testdate))
		WHEN '1' THEN '0' + CONVERT(char(1),
             DATEPART(M, @Testdate))
		WHEN '2' THEN DATEPART(M,@Testdate)
	END