a4apple (4/10/2014)
Nita Reddy (4/10/2014)
how do I pass day 16 in the codeWhat 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.. 😛
That is not what OP is doing. It's more like:
SELECT CONVERT(DATE, '20140101', 16); --Error
SELECT CONVERT(DATE, CURRENT_TIMESTAMP, 16); --Works
--Vadim R.