Friday, May 28, 2010

Get Montha Name from a Number in SQL

DECLARE  @monthInt  int
SET @monthInt = 5
select datename(month,dateadd(month, @monthInt - 1, 0)) as MonthName

No comments: