SQL FORMAT() Function

From http://www.w3schools.com (Copyright Refsnes Data)

# 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

From http://www.w3schools.com (Copyright Refsnes Data)