Nita Reddy (4/10/2014)
how do I pass day 16 in the code
What do you mean to say, when you want to pass 16 in the code. It's not even a valid one? Is it 106?
SELECT CONVERT(VARCHAR(64), GETDATE(), 16)????
Atleast my sql server version doesn't support, may be.. 😛
Good Luck 🙂 .. Visit www.sqlsaga.com for more t-sql code snippets and BI related how to articles.