CREATE TABLE EE_tbl_Orders (CUSTOMER varchar(20),ORDER_DATE datetime, ORDER_PRICE decimal(10,4));
INSERT INTO EE_tbl_Orders (CUSTOMER, ORDER_DATE, ORDER_PRICE) VALUES ('Fred','2015-08-20 20:30:40',1234.5678);
SELECT Customer, FORMAT(Order_Date,'yyyy MMM dd'), Order_Price
FROM EE_tbl_Orders
-- Results
-- Fred 2015 Aug 20 1234.5678
SELECT Customer, FORMAT(Order_Date,'yyyy MMM dd'), FORMAT(Order_Price,'C')
FROM EE_tbl_Orders
-- Results
-- Fred 2015 Aug 20 $1,234.57
SELECT Customer, FORMAT(Order_Date,'yyyy-MMM-dd'), FORMAT(Order_Date,'yyyy\/MMM\/dd'), FORMAT(Order_Price,'C')
FROM EE_tbl_Orders
-- Results
-- Fred 2015-Aug-20 2015/Aug/20 $1,234.57
Have a question about something in this article? You can receive help directly from the article author. Sign up for a free trial to get started.
Comments (1)
Commented: