Whats New in SQL Server Denali: Format(), a Most Wanted Function

Most of SQL Server developers/DBAs think that converting DateTime to a specific format is bit difficult as you need to remember specific format number, which you can use with CONVERT(). But now using SQL Server Denali, you can use a most demanded function FORMAT().