I have a select statement that when run on the live production server, returns mm-dd-yyyy regardless of what I do. this only happens though when selecting the date from an another aliased select. Simplified (as my sql is quite long):-
select name,age,dob from tblone as tbltemp1
in this select, dob always mm/dd/yyyy not dd/mm/yyyy
select dob from tbltemp1
Hope that explanation makes sense and if anyone can help?