date(m/dd/yyyy)
9/18/2006
In this above table i want to select only the month in this format
Sep 2006 . How to do that ?
Where @.DATE is your date variable
try SELECT DATENAME(month, @.DATE) + ' ' + DATENAME(year, @.DATE)
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment