timeTravel() - Set JSON time travel queries command
Sets system or business time for JSON time travel queries against a Db2® database.
Syntax diagram
Command parameters
- system_time
- This parameter specifies a YYYY-MM-DD formatted string or time stamp. The default value is the current date.
- business_time
- This optional parameter specifies a YYYY-MM-DD formatted string or time stamp. The default value is the current date.
Example
Example 1: Create a collection with
time travel enabled:
db.createCollection("timetravel", {systemTime:"sys",businessTime:"bus"})
Sample
output is as follows: Collection: TEST."timetravel" created. Use db.timetravel.
Example 2: Insert a document with business start
and end times:
db.timetravel.insert({name:"Joe", age:5, bus_start:"1990-05-30", bus_end:"1996-08-13"})
Sample output is as follows: OK
Example 3: Change the business time to 2012:
db.timeTravel(null, "2012-01-15")
Sample output is as follows: Setting system time: current date and business time: 2012-01-15