March 16, 2018 at 6:09 am
Hello
I have an SP that makes a comparison between records assesment date and getdate() i.e. for assessment in the past or future
I now want to unit test this such that the same results are returned every time
Problem is, getdate() is dynamic and (as far as i can see) outside of my control
So today, < getdate() will return a result and tomorrow it could differ, and the day after, ...
I'm doing unit testing in Visual Studio and want consistency otherwise testing will fail in the future
Is there a way to control the result of getdate() before calling the SP? or something else?
I believe it comes from the OS, so without changing it there (which I really don't want to do), is there any other way?
Thanks
- Damian
Viewing post 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy