Presenting a "Pretty" date

I typically date my items as

01/15/2008 for January 15, 2008.

Here is a pretty way of transforming this:

SELECT , CONVERT(VARCHAR(12), ExpDate, 1) AS Expires

-- create a #session table so it will be cleaned up when
you close out of the window
INTO [#Oneyear]
FROM Mytbl