I've got a stored procedure which does some sums on dates, which are
passed in as parameters.

So far so good, I can test the procedure by running it under the
Database Workbench debugger, and typing in the values of the input
parameters, and seeing whether the output is as expected. Or I can
automate this by writing a unit test stored procedure.

**BUT** the stored procedure I want to test does different things
depending on what the date is today, which it determines using the 'NOW'
pre-defined date literal.

So how do I test this procedure? How do I get 'NOW', used within the
procedure, to produce different timestamps as needed for the various
test cases? (Without, of course, typing different things into the
procedure itself, thus introducing the risk of getting it wrong and
introducing bugs when I later remove the test code.)

--
Tim Ward