Datetime parse returns wrong date.

Question

0.00/5 (No votes)

See more:

Data comes from a JSON file. The data seems to be "french" as the properties are in french.

ParseAndPrint("2023-03-30T19:15:22.000Z");
ParseAndPrint("2023-03-30T13:29:01.000Z");
ParseAndPrint("2023-03-30T01:32:55.000Z");

void ParseAndPrint(string s)
{
    var c = DateTime.Parse(s, CultureInfo.InvariantCulture);
    Console.WriteLine($"c : {c.ToShortDateString()}");
}

c : 2023-03-30
c : 2023-03-30
c : 2023-03-29

Any Thoughts ?

What I have tried:

I tried with and without CultureInfo.InvariantCulture.
I tried with the "fr-FR" culture (I think my data is using it ... )

Posted 13-Apr-23 5:29am

Maximilien

Updated 15-Apr-23 14:01pm

Add a Solution

Comments

[no name] 13-Apr-23 11:56am

If the time is (somewhere) before "noon", it appears you get the day before ("rounding" in the "short date" apparently). Reference the year, month and day explicitly in this case. (Display the DateTime as well to confirm).

Richard MacCutchan 13-Apr-23 11:56am

Those are Zulu (aka UTC) times. However when you display them your system adjusts them to your local timezone.

[edit]
2023-03-30T01:32:55.000Z UTC is 2023-03-29T20:32:55.000 in Quebec (or 21:32 if on DST).
[/edit]

4 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2023-04-13T05:50:00

Solution 1

Your system is using something - buts looks like ISO date format, not French.
Try parsing it use ParseExact instead:

C#

var c = DateTime.ParseExact(s, "yyyy-MM-ddTHH:mm:ss.fffZ", CultureInfo.InvariantCulture);

Posted 13-Apr-23 5:50am

OriginalGriff

Jean Ferre · Answer 2 · 2023-04-13T07:59:00

Solution 2

You can just use ToUnvisersalTime() like this

var c = DateTime.Parse(s).ToUniversalTime();

Posted 13-Apr-23 7:59am

Jean Ferre

cmarcotte · Answer 3 · 2023-04-15T13:04:00

Solution 3

This ISO date format is official date format in Canada or at least in some jurisdictions. Try with Canada(french) culture. I never tried DateTime with Canada(English) Culture.

A word of caution. In Canadian real-life you may face US, Great-Britain or ISO date format.

Posted 15-Apr-23 13:04pm

cmarcotte

Graeme_Grant · Answer 4 · 2023-04-15T14:01:00

Ah, everyone missed the important bit, this is being read from JSON. You need to deserialize to the correct object, the DateTimeOffset Struct (System) | Microsoft Learn[^].

Here is an example:

C#

using Newtonsoft.Json;

string rawJson = File.ReadAllText("sample_date.json");

Result result = JsonConvert.DeserializeObject<Result>(rawJson);

Console.WriteLine($"Date: {result.Date}");
Console.ReadKey();

public class Result
{

    [JsonProperty("date")]
    public DateTimeOffset Date { get; set; }
}

and here is the output (en-AU):

Date: 30/03/2023 1:32:55 AM +00:00

and here is the sample JSON used:

JavaScript

{
  "date": "2023-03-30T01:32:55.000Z"
}