Try to return day of the week

I would like to add a column that shows what is the weakday like Mon, Tues, Wed and so on...
based on the date that i have in another colum:
Here is what i have:

TimeStamp                                  Name
2011-06-20 22:59:47.050             KPI-X
2011-06-22 22:59:47.050             KPI-M
2011-06-25 22:59:47.050             KPI-I

So all what i want to do is add another column that shows weather it is Monday or Tues so forth based on TimeStamp date.  thanks for your help      
karinos57Asked:
Who is Participating?
 
anjosConnect With a Mentor Commented:
This should do it:

DATENAME(dw, Your_Date_Column)
0
 
karinos57Author Commented:
thnx
0
 
dqmqCommented:
alter table Yourtable add DayOfWeek as datename(dw,[timestamp])
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.