Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

ISO UTC DateTime format as default json output format in MVC 6 API response

Does anyone know how to configure MVC6's json output to default to a ISO UTC DateTime string format when returning DateTime objects?

In WebApi2 I could set the JsonFormatter SerializerSettings and convert datetimes however i'm a bit stuck with how to do this in MVC6

like image 594
sf. Avatar asked Jan 18 '17 20:01

sf.


2 Answers

And I just stumbled onto something that helped me figure it out.

Just in case anyone wants to know

In your Startup.ConfigureServices

services.AddMvc().AddJsonOptions(options =>
                {
                    options.SerializerSettings.DateTimeZoneHandling = DateTimeZoneHandling.Utc;
                });
like image 158
sf. Avatar answered Nov 18 '22 02:11

sf.


In case you've migrated to ASP.NET Core 3.0 the code that sf. has posted doesn't work anymore. To spare you some of my headache, here is what you need to do. First create a custom DateTime JSON converter:

public class DateTimeConverter : JsonConverter<DateTime> {
    public override DateTime Read(ref Utf8JsonReader reader, Type typeToConvert, JsonSerializerOptions options) {
        return DateTime.Parse(reader.GetString());
    }

    public override void Write(Utf8JsonWriter writer, DateTime value, JsonSerializerOptions options) {
        string jsonDateTimeFormat = DateTime.SpecifyKind(value, DateTimeKind.Utc)
            .ToString("o", System.Globalization.CultureInfo.InvariantCulture);

        writer.WriteStringValue(jsonDateTimeFormat);
    }
}

And then use it in your Startup.cs as follows:

services.AddControllersWithViews()
    .AddJsonOptions(options => {
        options.JsonSerializerOptions.Converters.Add(new DateTimeConverter());
    });

I hope this helps someone.

like image 19
Dimitar Dimitrov Avatar answered Nov 18 '22 01:11

Dimitar Dimitrov