September 7, 2008 01:41am pdt

1. chapmandew 2,085,990
2. angelIII 1,432,487
3. aneeshatti... 513,981
4. mark_wills 473,916
5. ee_rlee 315,195
6. brejk 226,005
7. dtodd 209,505
8. acperkins 186,813
9. momi_sa... 185,979
10. rickchild 172,740
11. BrandonG... 171,234
12. ptjcb 160,219
13. Thomasian 155,142
14. EugeneZ 151,550
15. sbagireddi 138,982
16. dportas 130,015
17. ScottPletc... 124,587
18. bashka_... 117,439
19. jgv 117,421
20. appari 114,979
21. PedroCGD 114,120
22. PFrog 113,160
23. chrismc 112,389
24. DanielWilson 110,274
25. tedbilly 107,990

1. angelIII 2,712,678
2. chapmandew 2,085,990
3. aneeshatti... 1,079,086
4. ptjcb 525,611
5. Yveau 517,373
6. mark_wills 473,916
7. dtodd 420,510
8. PFrog 383,188
9. dqmq 375,674
10. appari 351,126
11. imitchie 333,350
12. ee_rlee 315,195
13. acperkins 282,152
14. ScottPletc... 228,254
15. brejk 226,005
16. Lowfatsp... 223,289
17. matthews... 205,352
18. rboyd56 196,590
19. SQL_SE... 190,215
20. EugeneZ 188,259
21. momi_sa... 187,679
22. gbshahaq 177,810
23. tedbilly 176,329
24. DanielWilson 176,064
25. dportas 173,980

07.29.2007 at 08:40AM PDT, ID: 22727362

	[x] Attachment Details

Getting 2 character day with DATENAME

Asked by JackW9653 in SQL Server 2005, Databases Miscellaneous, MS SQL Server

Tags: datename

Hello Experts,

The following Select statement returns the day of the week. Does anyone know how to just return the first 2 characters of the weekday?

SELECT DISTINCT VisitDate, DATENAME(dw, VisitDate)As Day, S_time, Sch_Mins, Provider, Discipline, Case_Name
FROM tblScheduleData S ...

Thanks,

JackW9653Start Free Trial

Keywords: Getting 2 character day with DATENAME

	Title
1	DATENAME not converting smalldatetime
2	Weekday Name in Query
3	If select datename(dw,getdate(@S…
4	DATENAME showing same date acros…
5	SQL server miscalculation in weekday …
6	Weekday name from daynumber?

Loading Advertisement...

20080716-EE-VQP-32

Getting 2 character day with DATENAME

Asked by JackW9653 in SQL Server 2005, Databases Miscellaneous, MS SQL Server

Tags: datename

About this solution