timeTravel() - Set JSON time travel queries command

Sets system or business time for JSON time travel queries against a Db2® database.

Syntax diagram

Read syntax diagramSkip visual syntax diagramdb.timeTravel( system_time,business_time )

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