DECLARE @d DATETIME = '01/01/2011';
SELECT FORMAT ( @d, 'd', 'en-US' ) AS US_Result;

I am using above code in SQL Server 2008 R2 but it is encountering an error:

'FORMAT' is not a recognized built-in function name.

How can I use FORMAT function?

sql sql-server sql-server-2008
Edit
Report