Sunday 6 October 2013

10. Write a query to display the order date along with the sales order ID and the territory name. The order date should be displayed in the dd/mm/yyyy format.

select salesOrderid,Name,
Convert(Char(10),OrderDate,103)
as
'Order Date' from sales.salesOrderHerder s join sales.salesTerritory t
on t.TerritoryID= s.TerritoryID

No comments:

Post a Comment