How to display the name of the day 1

[Cpreston]

I have a view created which works fine and I am getting my dates using this


CONVERT (VARCHAR(11), dbrderHeader.DateRequired, 6)

However, I would like to add another column into the view that displays this result as a the name of the day.

02-jun-14 Mon
13-mar-15 Fri

What code do I need to use to make this happen within the view please

Thanks

 

[djj55]

DATENAME

djj
The Lord is my shepherd (Psalm 23) - I need someone to lead me!

 

[Cpreston]

Hi

Thanks for the reply, sorry but I am a novice as such to programming.

In the view design in the criteria how would I add the row so it shows the day for the example I gave

CONVERT (VARCHAR(11), dbrderHeader.DateRequired, 6)
This as an alias name of Date Required.

So what do I need to enter in the Column to make this work please

Thanks

 

[gk53]

just
CONVERT (VARCHAR(11), dbrderHeader.DateRequired, 6) + ' ' + DATENAME(WEEKDAY, dbrderHeader.DateRequired)

 

[Cpreston]

Thanks that worked perfectly, thanks for the help