SQL FORMAT() FUNCTION
Do you like this story?
SQL FORMAT() Function
The FORMAT() Function
The FORMAT() function is used to format how a field is to be displayed.
SQL FORMAT() Syntax
SELECT FORMAT(column_name,format) FROM table_name
|
Parameter
|
Description
|
column_name
|
Required. The field to be formatted.
|
format
|
Required. Specifies the format.
|
SQL FORMAT() Example
We have the following "Products" table:
Prod_Id
|
ProductName
|
Unit
|
UnitPrice
|
1
|
Jarlsberg
|
1000 g
|
10.45
|
2
|
Mascarpone
|
1000 g
|
32.56
|
3
|
Gorgonzola
|
1000 g
|
15.67
|
Now we want to display the products and prices per today's date (with today's date displayed in the
following format "YYYY-MM-DD").
We use the following SELECT statement:
SELECT ProductName, UnitPrice, FORMAT(Now(),'YYYY-MM-DD') as PerDate
FROM Products |
The result-set will look like this:
ProductName
|
UnitPrice
|
PerDate
|
Jarlsberg
|
10.45
|
2008-10-07
|
Mascarpone
|
32.56
|
2008-10-07
|
Gorgonzola
|
15.67
|
2008-10-07
|
This post was written by: Rajendra Prasad
Rajendra Prasad is a professional blogger, web designer and front end web developer. Follow him on Facebook
