Interviews - C# Corner

Satyaprakash Samantaray
How To Get Day Name from any Date ?
By Satyaprakash Samantaray in SQL Server onFeb 07 2017
  • Subhashkumar Yadav
    Feb, 2017 22

    SELECT DATENAME(DW,GETDATE()) as DayName

    • 4
  • Satyaprakash Samantaray
    Feb, 2017 7

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

    • 2
  • Thennarasu N
    Mar, 2017 17

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

    • 1
  • Suresh Kumar
    Nov, 2017 3

    SELECT DATENAME(dw,GETDATE()) as Dayname

    • 0
  • Khan Abrar Ahmed
    Sep, 2017 7

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

    • 0
  • Rajkiran Swain
    May, 2017 15

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

    • 0

Most Popular Companies

Most Popular Job Functions

MOST LIKED QUESTIONS