As Peter has said earlier u are selecting the orderdate in datetime format only.You should convert the date into required format while selecting the date like

select convert(varchar,Northwind.dbo.orderdate,102) as orderdate

FROM...