Jeff Moden (5/14/2008)
When using DATENAME, it's already in a character format, so you don't need to use CONVERT or CAST...SELECT DATENAME(yy,GETDATE())+RIGHT('00'+DATENAME(wk,GETDATE()),2)
Never thought of this 😛 hehehe thanks... thats the reason i used a convert hehehe .
This seems to work too..
SELECT DATENAME(yy,GETDATE())+RIGHT(DATENAME(wk,GETDATE()),2)
Why does some members tend to double post? :hehe:
"-=Still Learning=-"
Lester Policarpio