Date formats

This code snippet is for getting different date formats

date: 05-sep-2009

SELECT CONVERT(char,GETDATE(),101)              //  09/05/2009
SELECT CONVERT(char,GETDATE(),102)              //  2009.09.05
SELECT CONVERT(char,GETDATE(),103)              //  05/09/2009
SELECT CONVERT(char,GETDATE(),1)                //  09/05/2009

Select Convert(char,,101) from table name.

 select convert(char,edate,101) from employee