Write a query to display the earliest date an order has been placed, formatted a

Question

Write a query to display the earliest date an order has been placed, formatted as month dd, yyyy.

SalesRep Customer PK ReplD int varchar(20) varchar(20) PK CustomerlD int O--OLastName FirstName LastName varchar(20) FirstName varchar(20) Street City State Zipcodechar(5) CommissionRate decimal(10,2) varchar(20) varchar(20) char(2) Order Balance decimal(10,2) FK1 ReplD int FK1 CustomerlD int OrderDat date ShipDate date Part PK PartID int OrderLine Description varchar(20) UnitsOnHand int ItemClass char(4) Retail Cost PK,FK1 OrderlD int decimal(10,2) decimal (10,2) Quantityint

Explanation / Answer

Query to display the earliest date an order has been placed, formatted as month dd, yyyy.?

SELECT DATENAME(MM, GETDATE()) + ' ' + DATENAME(DD, GETDATE()) + ', ' + DATENAME(YYYY, GETDATE()) AS 'Formatted Date';

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.