Example
Format a date:
DECLARE @d DATETIME = '12/01/2018';
SELECT FORMAT (@d, 'd', 'en-US') AS 'US English Result',
FORMAT (@d, 'd', 'no') AS 'Norwegian Result',
FORMAT (@d, 'd', 'zu') AS 'Zulu Result';
Definition and Usage
The FORMAT() function formats a value with the specified format (and an optional culture in SQL Server 2017).
Use the FORMAT() function to format date/time values and number values. For general data type conversions, use CAST() or CONVERT().
Syntax
FORMAT(value, format, culture)