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?
mm-dd-yyyy
format but later on you indicate it'smm/dd/yyyy
notdd/mm/yyyy
format as expected.dob
column, where you are executing the query and consuming the results, and possibly the locale settings of the system where you are executing the query as well.