6
Reply

How To Get Day Name from any Date ?

Satyaprakash Samantaray

Satyaprakash Samantaray

Feb 07, 2017
1.3k
2

    SELECT DATENAME(DW,GETDATE()) as DayName

    Subhashkumar Yadav
    February 22, 2017
    4

    SELECT DATENAME(dw,'05/10/1991') as theDayName

    Satyaprakash Samantaray
    February 07, 2017
    2

    select datename(dw,getdate()) --Thursday select datepart(dw,getdate()) --2

    Thennarasu N
    March 17, 2017
    1

    SELECT DATENAME(dw,GETDATE()) as Dayname

    Suresh Kumar
    November 03, 2017
    0

    SELECT DATENAME(weekday,CAST('08/09/2017' AS date)) AS [DayName]

    Khan Abrar Ahmed
    September 07, 2017
    0

    //default locale System.DateTime.Now.DayOfWeek.ToString(); //localized version System.DateTime.Now.ToString("dddd");

    Rajkiran Swain
    May 15, 2017
    0