C# with mongodb DateTime Convert

Question

I want to convert "ISODate(\"2014-11-13T18:43:33.868Z\")" to c# datetime ex 2014-11-13 18:43:33. Value "ISODate(\"2014-11-13T18:43:33.868Z\")" take from MongoDB collection.

Please Help.

Have you made any attempt yourself to solve this? What specific problem are you facing? — DGibbs, Nov 13 '14 at 16:48
that's not a C# datetime..looks more like a `TimeStamp` format please show your C# code that you are currently using also do a google search since there are many examples out there and this has already been asked on SO previously.. show more effort please.. http://stackoverflow.com/questions/3556144/how-to-create-a-net-datetime-from-iso-8601-format — MethodMan, Nov 13 '14 at 16:54
The C# MongoDB driver will do this sort of conversion for you. If you post your code we can see what you might be doing wrong. — JohnnyHK, Nov 13 '14 at 17:01

score 5 · Answer 1 · edited Nov 26 '18 at 03:45

5

You can set DateTime in C# to UTC

var createDate = DateTime.SpecifyKind(DateTime.Now, DateTimeKind.Utc)

or

dateTime = DateTime.SpecifyKind(dateTime, DateTimeKind.Utc)

Then insert type DateTime into mongodb It worked in my case.

edited Nov 26 '18 at 03:45

Dale K

25,246
15
42
71

answered Nov 26 '18 at 02:35

Nguyễn Thành Nghĩa

537
6
13

score 2 · Answer 2 · edited May 23 '17 at 10:30

2

You can store your date as a BsonDateTime object when you pull it from the database, then convert it as follows:

DateTime dt = bdt.ToUniversalTime();

And you may find this question useful to learn more about how ToUniversalTime() works.

edited May 23 '17 at 10:30

Community

1
1

answered Nov 13 '14 at 19:22

Augustin Popa

1,423
1
19
22

score 1 · Answer 3 · answered Nov 13 '14 at 20:12

If I understand clearly, just because it writes ISODate in your string, that doesn't make it ISO 8601 format. The "O" or "o" standard format specifier complies ISO 8601 format and which is "yyyy'-'MM'-'dd'T'HH':'mm':'ss'.'fffffffK" custom format string for a DateTime. That doesn't match with your string format.

If your all strings has a stable format like this, you can use custom date and time formats with literal string delimiter like;

string s = "ISODate(\"2014-11-13T18:43:33.868Z\")";
string format = "'ISODate(\"'yyyy-MM-dd'T'HH:mm:ss.fff'Z\")'";
DateTime date;
if(DateTime.TryParseExact(s, format, CultureInfo.InvariantCulture,
                          DateTimeStyles.None, out date))
{
    Console.WriteLine (date);
}

If you want to string representation of your DateTime with "2014-11-13 18:43:33" format, you can use DateTime.ToString() method like;

date.ToString("yyyy-MM-dd HH:mm:ss", CultureInfo.InvariantCulture);

C# with mongodb DateTime Convert

3 Answers3

Linked