Wednesday, July 10, 2013

DATENAME not work

SQL server 2008 SP3 not work for this : select DATENAME(month, '2012-07-01')
it will show result 07 instead of JUL.
well, sql server 2008 R2 working fine.