You can use
SET DATEFORMAT dmy;
Or, you can use CONVERT in the select statement. Date formats are usually better controlled in the client.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs