FORMAT

Last updated 6 months ago

Description

Returns a value formatted with the specified format and optional culture (FORMAT in Transact-SQL).

FORMAT( value, format [, culture])

value: String expressions to give format.

format: Desired format.

culture (Optional): NVarchar argument specifying culture. If it is not specified, takes the languages of the current session.

NULL if the culture parameter is invalid, otherwise, it follows the next data types:

SELECT FORMAT(CAST('2022-01-24' AS DATE), 'd', 'en-gb')  AS 'Great Britain';

  GREAT BRITAIN|      
---------------+
     24/01/2022|

SELECT FORMAT(244900.25, 'C', 'cr-CR')  AS 'CURRENCY';

       CURRENCY|      
---------------+
    ₡244,900.25|

No issues were found.

No related EWIs.