Most people that use SQL Server are familiar with formatting dates inside SQL Server. The common approach is:

convert(varchar, getdate(), 106) -- Displays a date in the format 25 Jan 2008

That is all fine and good if your requirements are satisfied with the formats available inside SQL Server. SQL Server does provide a decent number of formats. Here is the list right from the SQL Server help:

Source: DZONE