Home Forums SQL Server 2005 T-SQL (SS2K5) datename with varchar data type RE: datename with varchar data type
Bruce W Cassidy
SSChampion
Points: 12668
More actions
July 16, 2009 at 4:08 pm
#1025938
[font="Verdana"]DATENAME() does require two arguments. The first argument tells SQL Server which part of the date name you want (year, month, day, etc). The second argument is the date for which you want the name.[/font]