SQL format () function usage and simple example, sqlformat

SQL format () function usage and simple example, sqlformat

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

SQL FORMAT () syntax

SELECT FORMAT(column_name,format) FROM table_name; 

Parameters	Description
Column_name	Required. The field to be formatted.
Format	Required. Required format.

 Demo Database

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

The data from the "Products" table is as follows:

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 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

 SQL FORMAT () instance

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

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

The usage and simple examples of the preceding SQL format () function are all the content shared by Alibaba Cloud. I hope you can give us a reference and support for the help house.