SQL Server video to test what an application would do in the past or in the future

By:   |   Comments   |   Related: More > Testing




Problem / Solution

Testing T-SQL application code that has time dependencies can be a very difficult and error prone task. By borrowing a technique from Test-Driven-Development and using a mock-time instead of the real time it becomes easy to test how a stored procedure or function would behave at some other time in the past or the future. This is done by replacing calls to getdate() from within application code with a function that returns the mock-time when run during a test.

Key Learning Items
  • How to create your own current date/time using a date in the past or future
  • Examples using DATEPART, DATEFROMPARTS, DATEADD
  • Learn about CONTEXT_INFO()
Read Companion Tip

Click Here






get scripts

next tip button



About the author
MSSQLTips author Andy Novick Andy Novick is a SQL Server Developer in the Boston area with 25 years of database and application development experience.

View all my tips



Comments For This Article