datename sql function not showing the correct day using -'sql,sql-server,sql-server-2008,tsql,sql-server-2012'

datename sql function not showing the correct day  using -'sql,sql-server,sql-server-2008,tsql,sql-server-2012'

I went online and saw for example that 03 Nov 2011 is Thursday and 04 Nov 2011 is Friday. I used the function

SELECT datename (dw, 04-11-2011) on my server and it says Saturday instead of Friday. How can I set it up to display correctly? Or what am I missing?

Thank you all for your inputs. However, most of you pointed out the format I am using and not the fact that it isn't set up correctly. Someone posted (and think deleted his comment) of this link: . This combined with your answers, solved my problem.

asked Sep 7, 2015 by rajesh
0 votes

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
Anti-spam verification:
To avoid this verification in future, please log in or register.