sql format of function usage and simple examples

The FORMAT() function is used to format the display of the field.

SQL FORMAT () syntax


SELECT FORMAT(column_name,format) FROM table_name;

参数	描述
column_name	必需。要格式化的字段。
format	必需。规定格式。

Demo database

In this tutorial, we will use the well-known Northwind sample database.

Here is the data from table "Products" :

ProductID	ProductName	SupplierID	CategoryID	Unit	Price
1	Chais	1	1	10 boxes x 20 bags	18
2	Chang	1	1	24 - 12 oz bottles	19
3	Aniseed Syrup	1	2	12 - 550 ml bottles	10
4	Chef Anton's Cajun Seasoning	2	2	48 - 6 oz jars	21.35
5	Chef Anton's Gumbo Mix	2	2	36 boxes	25

Examples of SQL FORMAT ()

The following SQL statement selects the product name and the price for the day (formatted as YYYY-MM-DD) from the table "Products" :


SELECT ProductName, Price, FORMAT(Now(),'YYYY-MM-DD') AS PerDate 
FROM Products;