Pre Exam Test Practice (SSC | Banking | IAS | GATE | State Level | CLAT | Railways | Insurance | Teaching Exams | NDA | Defence | IES |State Exam )

Organizational Research By

Surprising Reserch Topic

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

Related Hot Questions

Government Jobs Opening