SQL Server FORMAT() Function

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

Use the FORMAT() function to format date/time values and number values. For general data type conversions, use

Cast()

Syntax

Format(

Parameter Values

Parameter

Description value

Technical Details

Works in:

More Examples

Example

Format a number:

Select

FORMAT(123456789, '##-##-#####');

Previous

Next