SQL Server FORMAT() Function
Clash Royale CLAN TAG#URR8PPP
<!--
main_leaderboard, all: [728,90][970,90][320,50][468,60]-->
SQL Server FORMAT() Function
❮ SQL Server Functions
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';Try it Yourself »
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)Parameter Values
| Parameter | Description |
|---|---|
| format | Required. The value to be formatted |
| value | Required. The format pattern |
| culture | Optional. Specifies a culture (from SQL Server 2017) |
Technical Details
| Works in: | SQL Server (starting with 2012), Azure SQL Database |
|---|
More Examples
Example
Format a number:
SELECT
FORMAT(123456789, '##-##-#####');Try it Yourself »
❮ SQL Server Functions