Thursday, 8 November 2012
Monday, 20 February 2012
Monday, 23 January 2012
Get day name from a date in sql server
Sometimes one would want to know the weekday name of a certain date. so here is a quick function that can do all the work, all that you need to do is to pass the date.
CREATE FUNCTION dbo.getWeekDayName
(@datename DATETIME)
RETURNS VARCHAR(25)
AS
BEGIN
DECLARE @weekdatename VARCHAR(50);
SELECT @weekdatename = DATENAME(dw , @datename)
RETURN @weekdatename
END
how to use the function
select dbo.getWeekDayName('20121215')
CREATE FUNCTION dbo.getWeekDayName
(@datename DATETIME)
RETURNS VARCHAR(25)
AS
BEGIN
DECLARE @weekdatename VARCHAR(50);
SELECT @weekdatename = DATENAME(dw , @datename)
RETURN @weekdatename
END
how to use the function
select dbo.getWeekDayName('20121215')
Thursday, 12 January 2012
Monday, 9 January 2012
Subscribe to:
Posts (Atom)