string asofdate = db.ExecuteScalar(cmd).ToString();

Upon executing the above line of code, I get data in the format of
09/30/2010 12:00:00AM

But I want to format this into 09-Sep-2010.

How can I do this?
thanks
nath