The use of the SQL format () function and a simple instance _mysql

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

SQL FORMAT () syntax

SELECT FORMAT (Column_name,format) from table_name; 

Parameters	Description
column_name	Necessary. The field to format.
Format	Necessary. Specified format.

Demo Database

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

Here is the data selected from the Products table:

Unit Price

ProductID	ProductName	SupplierID	CategoryID
1	Chais	1	1	Boxes X 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	Boxes	25

SQL FORMAT () instance

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

SELECT ProductName, Price, FORMAT (now (), ' Yyyy-mm-dd ') as perdate from 
; 

The use of this SQL format () function and a simple example is a small series to share all the content, hope to give you a reference, but also hope that we support the cloud habitat community.