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 |
The Altova MissionKit is an integrated suite of tools ideal for:
- XML development
- Web & Web services development
- Data mapping & integration
- Rendering & publishing XML & database data
- XBRL validation, taxonomy editing, transformation & rendering
The MissionKit for XML Developers includes XMLSpy® - the industry-leading XML editor; MapForce® - a
graphical data mapping, conversion, and integration tool; StyleVision® - a visual XSLT stylesheet designer;
DiffDog® - an XML-aware diff/merge tool; and 2 additional tools.
Try all 6 products free for 30 days!
Download a fully-functional free trial
|
|
|
|
