What is Timestamp in MongoDB: Explanation and Usage

In MongoDB, a Timestamp is a special BSON data type that stores a 64-bit value representing time and an incrementing ordinal. It is mainly used for internal purposes like replication and change tracking, not as a general date-time value.

How It Works

Think of MongoDB's Timestamp as a unique time marker that combines the current time with a counter. The first part stores the number of seconds since January 1, 1970 (Unix epoch), and the second part is an incrementing number to keep track of multiple events happening at the same second.

This makes each Timestamp unique even if many events occur simultaneously. MongoDB uses this internally to order operations, especially in replication where it tracks changes across servers to keep data consistent.

Unlike a regular date, which just shows a point in time, the Timestamp also helps MongoDB know the exact sequence of operations, which is crucial for syncing data correctly.

Example

This example shows how to create and view a Timestamp in MongoDB using the shell.

javascript

var ts = new Timestamp();
printjson(ts);

// Accessing the time and increment parts
print('Time:', ts.getTime());
print('Increment:', ts.getInc());

Output

{ "$timestamp" : { "t" : 1688000000, "i" : 1 } }
Time: 1688000000
Increment: 1

When to Use

Use MongoDB Timestamp mainly when you need to track the order of operations or changes in your database, such as in replication or change streams. It is not meant for storing general date and time information for your application data.

For example, if you build a system that listens to database changes, the Timestamp helps you know exactly when and in what order those changes happened. For regular date storage, use the Date type instead.

Key Points

• Timestamp stores time plus an increment to ensure uniqueness.
• It is mainly used internally by MongoDB for replication and change tracking.
• Not suitable for general date/time storage in application data.
• Use Date type for regular date and time values.

Key Takeaways

MongoDB's Timestamp combines seconds since epoch with an increment for uniqueness.

It is primarily used internally for replication and change tracking.

Do not use Timestamp for regular date/time data in your application.

Use the Date type for storing normal date and time values.

Timestamp helps MongoDB order operations precisely in distributed setups.