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: https://msdn.microsoft.com/en-us/library/ms181598.aspx
. This combined with your answers, solved my problem.