MSSQLString FunctionsFORMAT
STUFF

FORMATString Functions

STRING_AGG

Formats a value as a specified format string.

Syntax

FORMAT(value, format [, culture])

Example

Enter values below to update the example in real time.

price
formatted_price
products
order_date
date_kr
orders
-- 숫자 포맷 (천 단위 구분)
SELECT FORMAT(price, 'N0', 'ko-KR') AS formatted_price
FROM products;

-- 날짜 포맷
SELECT FORMAT(order_date, 'yyyy년 MM월 dd일', 'ko-KR') AS date_kr
FROM orders;