SQL FORMAT () function

FORMAT () function

The Format function is used for formatting 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. prescribed format.

SQL FORMAT () instance

We have the following "Products" table:

prod_id	ProductName	Unit	UnitPrice
1	Gold	+ G	32.35
2	Silver	+ G	11.56
3	Copper	+ G	6.85

Now, we want to show the name and price of each day's date (the date is displayed in the format "YYYY-MM-DD").

We use the following SQL statement:

SELECT ProductName, UnitPrice, FORMAT (now (), ' Yyyy-mm-dd ') as Perdatefrom products

The result set looks like this:

ProductName	UnitPrice	perdate
Gold	32.35	12/29/2008
Silver	11.56	12/29/2008
Copper	6.85	12/29/2008

SQL FORMAT () function