JSON date from tweeter to C# format

Question

How to format a JSON date obtained from twitter to a C# DateTime ? Here is the format of the date I receive :

"Tue, 19 Feb 2013 13:06:17 +0000"

Can I do it with JSON.NET ?

Persse

What happens when you do DateTime.Parse("Tue, 19 Feb 2013 13:06:17 +0000")? – Causalgia

Duplicate https://mcmap.net/q/827566/-c-parse-json-date – Empressement

Answer 1

Solved with use of DateTime.ParseExact

-> http://blog.kevinyu.org/2012/07/handling-json-in-net.html

Link Update: the linked blog post is offline. It cached copy can still be referenced via the Way Back Machine Internet Archive.

The common .NET code copied from the blog post is:

public const string Const_TwitterDateTemplate = "ddd MMM dd HH:mm:ss +ffff yyyy";

DateTime createdAt = DateTime.ParseExact((string)jo["created_at"], 
Const_TwitterDateTemplate, new System.Globalization.CultureInfo("en-US"));

where

• variable jo is a JSON object representing the created_at date property, but effectively the Twitter date string goes into this parameter

Persse

Thanks for link, next time please post date format here, parsing twitter date is a common task. – Isobelisocheim

The date format string in this example is incorrect. ffff is the format specifier for ten thousandths of a second, and the +0000 in a Twitter date indicates the hours and minutes offset from UTC. The correct format string is "ddd MMM dd HH:mm:ss zzz yyyy". Custom Date and Time Format Strings in .NET – Britnibrito

Answer 2

Part of code from flow's answer.

public const string Const_TwitterDateTemplate = "ddd MMM dd HH:mm:ss +ffff yyyy";

DateTime createdAt = DateTime.ParseExact((string)jo["created_at"], Const_TwitterDateTemplate, new System.Globalization.CultureInfo("en-US"));

Anibalanica

Answer 3

The answers above that use the ffff format specifier seem to return the correct result, but technically this is wrong. ffff is the format specifier for ten thousandths of a second, and the +0000 in a Twitter date indicates the hours and minutes offset from UTC. See the format below:

string twitterTime = "Wed Feb 22 15:49:01 +0000 2017";
string twitterTimeformat = "ddd MMM dd HH:mm:ss zzz yyyy";

DateTime dateTime = DateTime.ParseExact(twitterTime, twitterTimeformat,
    CultureInfo.InvariantCulture, DateTimeStyles.AdjustToUniversal);
Console.WriteLine(dateTime);

Result: 2/22/2017 3:49:01 PM

You can edit the DateTimeStyles enumeration to return the local time instead of UTC if desired.

Custom Date and Time Format Strings

DateTimeStyles Enumeration

Britnibrito

Answer 4

It's DateTimeOffset not DateTime. Following should work.

DateTimeOffset parsed = DateTimeOffset.Parse("Tue, 19 Feb 2013 13:06:17 +0000");

Tauten

Answer 5

I needed a PowerShell variant of these answers and the following worked for me.

PS> $Created_At = 'Fri Jun 05 18:15:48 +0000 2020'
PS> [datetime]::ParseExact($Created_At,'ddd MMM dd HH:mm:ss zzz yyyy',(Get-Culture))

Friday, June 5, 2020 1:15:48 PM

Beebeebe