SQL Convert Date not working

I'm having an issue with converting a date from YYYY-MM-DD to DD/MM/YYYY. When I put CONVERT(date,sh.Order_Date,101), it still comes back as YYYY-MM-DD. I tried changing the style to 102, 103, 104, 105, etc. and it keeps returning the same format each time. The data type for OrderDate is datetime, so I'm not sure what the issue is. I even tried convert(date,cast(OrderDate as date),101) and got the same result. Can someone help me?
FVIAHAsked:
Who is Participating?
 
tim_csConnect With a Mentor Commented:
SELECT
   CONVERT(VARCHAR(10),sh.Order_Date,101)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.