I'm currently working with prototyping some stuff with a dump of a MySQL (5.7) database where much of the data is time dependent. Most of the queries I write use the
NOW() function and the results change over time as we get further away from the time the dump was taken.
Is there a way to "lock the database in time" to the time of the dump or is there some other way to deal with this sort of situation, other than replacing all references to
NOW() with a hard coded time stamp?