Web-Api datatime serialization issue

Question

I have some issue with the return of a WEB API. This API processes the data and returns an object of type List <Dictionary <string, object >>. The problem is that when returning a date (datetime) the return format change depending on the server on which the site is installed.

For example I have these two cases:

the first is the correct size, while the second is to wrong.

I have the following statement in the code that converts (should convert) the date to the desired format:

dict.Add(dc.Caption, ((DateTime)dr[dc.Caption]).ToString("yyyy-MM-dd HH:mm:ss"));

Can you help me?

Bye Davide

stackoverflow.com/questions/13817108/…

Palin
– Palin

2017-03-07 15:50:05 +00:00
Commented Mar 7, 2017 at 15:50 — Palin
– Palin, Commented Mar 7, 2017 at 15:50

CodeCaster · Accepted Answer · 2017-03-07 15:54:33Z

The colon (:) in a DateTime format string does not always translate to a colon, it stands for "the time separator according to the current culture". See also MSDN: Custom Date and Time Format Strings.

You can see this in this code sample, using the Finnish culture, where the period is used as a time separator:

var finnishCulture = new CultureInfo("fi-FI");

Thread.CurrentThread.CurrentCulture = finnishCulture;

Console.WriteLine(DateTime.Now.ToString());
Console.WriteLine(DateTime.Now.ToString("HH:mm"));
Console.WriteLine(DateTime.Now.ToString(@"HH\:mm"));

This prints:

7.3.2017 15.58.47
15.58
15:58

Perhaps let WebAPI do the serialization for you, or if you're sure you want to serialize it yourself, escape the colon: \:.

Collectives™ on Stack Overflow

Web-Api datatime serialization issue

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related