C# (MongoDB.Driver) - Convert ISODate to IST

 using MongoDB.Driver;

using System;

var client = new MongoClient("mongodb://localhost:27017");

var database = client.GetDatabase("mydatabase");

var collection = database.GetCollection<BsonDocument>("mycollection");

var documents = collection.Find(FilterDefinition<BsonDocument>.Empty).ToList();

foreach (var doc in documents)

{

    var date = doc["createdAt"].ToUniversalTime().AddHours(5.5); // Convert to IST

    Console.WriteLine(date.ToString("dd-MM-yyyy HH:mm:ss"));

}

• Tweet
• Share
• Share
• Share
• Share

Sign up here with your email