Get day name from Datetime using SQL Server 2008 R2

Question

I need to get day name from the given datetime using the SQL Server 2008 R2.

Example:

Given date:

'2014-11-14 00:00:00'
'2014-11-15 00:00:00'

Expected result:

Date              Day Name of Date
----------------------------------
2014-11-14        Friday
2014-11-15        Saturday

Answer 1

select DATENAME(weekday,getdate())

SELECT CONVERT(VARCHAR(10), '2014-11-14 00:00:00', 105) AS DATE,
       Datename(weekday, '2014-11-14 00:00:00')         AS DayNameofDate