Flash cards
Review the key moves
1/4
Core idea
What is the main idea behind SQL Server FORMAT() Function?
Lesson checks
Practice each idea before moving on
Short Mimo-style checks built from this lesson's code, terms, and sequence.
1Quick choice
Which statement best captures the main point of this lesson?
2Fill blank
Complete the missing token from the example code.
___ @d DATETIME = '12/01/2018';3Order
Put the learning moves in the order that makes the concept easiest to apply.
The FORMAT() function formats a value with the specified format (and an optional culture in SQL Server 2017).
Definition and Usage
SQL Server FORMAT() Function
Example
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
)Parameter Values
| Parameter | Description |
|---|---|
| value | Required. The value to be formatted |
| format | 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 |
|---|