Converting to DateTime in json.net

Question

I'm trying to deserialize the following:

{"ts":"2012-04-22 04:14:50,669", "msg":"Hello"}

into

public class LogEntry
{
    public DateTime Ts { get; set; }
    public string Msg { get; set; }
}

using

var logEntry = JsonConvert.DeserializeObject<LogEntry>(line);

But get a JsonSerializationException saying "{"Error converting value \"2012-04-22 04:14:28,478\" to type 'System.DateTime'. Line 1, position 31."}. I cannot change the log format.

I think I might need to parse the date string myself using a Converter. However, I cannot find any examples of JsonConverter that seem relevant. Specifically how to read the value from the reader in the ReadJson method.

Are there any simple examples that I should look at? Or am I going about this the wrong way?

This question over at stack apps looks like it does what you need: stackapps.com/questions/1175/… — ilivewithian
– ilivewithian, Commented Apr 25, 2012 at 8:49
Thanks. Yes, I saw it before, but since the code in the ReadJson method is commented out I didn't see it as a very good example. — Niklas
– Niklas, Commented Apr 25, 2012 at 8:55
Scroll down through the example, there is an uncommented version of the ReadJson method. Either way, the basic principle of the example is sound. — ilivewithian
– ilivewithian, Commented Apr 25, 2012 at 9:05
The comma is because it's the decimal separator. I'm more interested in the general way of helping Json.net parse something. — Niklas
– Niklas, Commented Apr 25, 2012 at 11:31

raveturned · Accepted Answer · 2012-04-25 09:02:53Z

5

The format on your DateTime string uses a comma for the decimal separator (,478). You may be able to initialise a JsonSerializerSettings object (documented here) with an appropriate Culture, and then deserialise using DeserializeObject<T>(value, settings) (documented here). This would deserialise using the culture you specify rather than the default InvariantCulture.

answered Apr 25, 2012 at 9:02

raveturned

2,6771 gold badge25 silver badges32 bronze badges

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

2 Comments

Niklas Over a year ago

Looks nice. However, my version of json.net (which I currently cannot upgrade for dependency reasons) doesn't have the Culture or Date* properties on JsonSerializerSettings.

raveturned Over a year ago

Unfortunate. :/ In that case I guess you're forced down the custom Converter route. Is this SO entry useful at all?

Steve · Accepted Answer · 2012-04-25 08:58:44Z

-1

I suspect the issue is because the value you are getting is using a comma as the decimal separator which suggests it was created in a locale that uses commas (e.g. a lot of European languages other than English). You could try changing your locale to match so that the parsing would work?

answered Apr 25, 2012 at 8:58

Steve

8,5111 gold badge29 silver badges37 bronze badges

Collectives™ on Stack Overflow

Converting to DateTime in json.net

2 Answers 2

2 Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Linked

Related