Altair® Panopticon

 

NOW Timestamp Functionality

The MongoDB plugin can insert (at execution) the current timestamp in multiple formats. This allows for query documents to fetch records as compared to the current Date/Time without the need to be updated each time a query is executed.

This option has the following options:

  • NOWPOSIX()

This creates the Date/Time in POSIX format.

  • NOWISODATE()

This creates the Date/Time in the standard date format of MongoDB.

Deciding which call to use is based on how the time column is stored in the database being queried.

In addition, NOW functions can also take one parameter, an integer, which can alter the current timestamp by a number of seconds. A negative integer would define seconds into the past and a positive would define seconds into the future.

For example, this query looks only at the past five seconds worth of documents: