SQL FORMAT() Function

« Previous Chapter Learn MySQL »

The FORMAT() Function

The FORMAT() function is used to format how a field is to be displayed.


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 Safari 1000 g 10.45
2 Kisan 1000 g 32.56
3 Burger 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
Safari 10.45 2015-10-07
Kisan 32.56 2015-10-07
Burger 15.67 2015-10-07

« Previous Chapter Learn MySQL »

Have Any Suggestion? We Are Waiting To Hear from YOU!

Your Query was successfully sent!