Convert C# DateTime into MongoDB format

Question

I create manually a BsonDocument. I have to add a datetime into the document. How can I convert C# Datetime to MongoDB format ?

Thanks

Andrew Orsich · Accepted Answer · 2012-02-16 10:33:11Z

11

You no need to do anything. Just assign date to bson document:

var bsonDocument = new BsonDocument();
bsonDocument["date"] = DateTime.Now;

Driver will automatically convert your datetime to mongodb format and store in as UTC date, and will convert back to your local timezone back when you will read it (actually you can change this behavior via driver settings). So, take it in the mind that dates in mongodb always in UTC format.

Documentation about mongodb DateTime:

The BSON Date/Time data type is referred to as "UTC DateTime" in the BSON spec.

A BSON Date value stores the number of milliseconds since the Unix epoch (Jan 1, 1970) as a 64-bit integer. v2.0+ : this number is signed so dates before 1970 are stored as a negative numbers.

answered Feb 16, 2012 at 10:33

Andrew Orsich

53.8k17 gold badges142 silver badges134 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

hotips Over a year ago

Thanks ! Visual Studio underlined at one time the line... but it compile and works now ;)

Collectives™ on Stack Overflow

Convert C# DateTime into MongoDB format

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related