Datetime parsed to localTime.

[Sarogatip]

While passing DateTime object to DataTablesResult.Create method it is parsed to UTC time zone. In order to change it I had to include your whole project to my solution just to change:

static StringTransformers()
{
     RegisterFilter<DateTimeOffset>(dateTimeOffset => dateTimeOffset.ToLocalTime().ToString("g"));
     RegisterFilter<DateTime>(dateTime => dateTime.ToLocalTime().ToString("g"));
}

to:

static StringTransformers()
{
     RegisterFilter<DateTimeOffset>(dateTimeOffset => dateTimeOffset.ToString("g"));
     RegisterFilter<DateTime>(dateTime => dateTime.ToString("g"));
}

Is there any better way to do that? I'd like to display exactly this date which is stored in my database.
Thanks for any tips.

[mcintyre321]

Before I give you a detailed answer, let me check I understand:

You
a/ store UTC times in your database and
b/ want to display them in UTC to the user (no matter what TZ they are currently in)?

[mcintyre321]

Also, are you using date range column filters?

If not you can just use a transform to render the underlying string type as you like: https://github.com/mcintyre321/mvc.jquery.datatables/wiki/How-to-manipulate-format-prettify-the-output-column-data-after-the-filters-have-been-applied

[mcintyre321]

Also I think StringTransformers.RegisterFilter is public, so you can overwrite the DateTime transformers from your global.asax.cs/Startup.cs without having to include the whole project as source.

[Sarogatip]

You understand me correctly.
Using date range column filter worked form me like a charm, but it forced me to change each controller where I use DataTable.Create().
If you could post how to overwrite StringTransformers.RegisterFilter in global.asax.cs I would be really greatfull.

[mcintyre321]

I haven't had a chance to test this, but you should be able to do this:

protected void Application_Start(object sender, EventArgs e) {
{
     StringTransformers.RegisterFilter<DateTimeOffset>(dateTimeOffset => dateTimeOffset.ToString("g"));
     StringTransformers.RegisterFilter<DateTime>(dateTime => dateTime.ToString("g"));
}

[Sarogatip]

It works very well. Thank you very much.