Thanks so much Everyone.

The query suggested by Peter works flawless.

Thanks once again.

Javid

Yes, That's correct.

If the N takes a value 3, then the months March and April should be ignored too.

Yes, I agree with you Jeff. That's the reason I had mentioned this as a workaround rather than the best possible fix.

The final datetime value obtained from timestamp being meaningless...

Ok, I managed to fix the issue. Though this appears to be a quick workaround, I believe this will work long term (atleast for next 100 years in my case)

CONVERT(DATETIME,...

I would prefer to have a row versioning. I believe if I start using dates, then I might have to add some additional triggers that needs to be executed as...

Thats good as long as you know how to fix it. I have been breaking my head in the past couple of days to actually come up with the right...

True,

I completely agree with you that it is a bug. I was just looking for a quick workaround to keep the process going until I fix it with a elegant...

Actually I am working on some stored procedures that was written by another developer. In my case, the table has a timestamp column, which gets cast to a datetime value...