How to convert a string date to date format ?

Question

1.00/5 (1 vote)

See more:

How can I convert this format "Fri Jan 31 2014 00:00:00 GMT-0800 (Pacific Standard Time)" to just 2014-01-31 in c#

What I have tried:

How can I convert this format "Fri Jan 31 2014 00:00:00 GMT-0800 (Pacific Standard Time)" to just 2014-01-31 in c#

Posted 16-Dec-16 0:43am

Member 10481218

Updated 16-Dec-16 1:09am

Add a Solution

3 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)

F-ES Sitecore · Answer 1 · 2016-12-16T01:00:00

C#

string text = "Fri Jan 31 2014 00:00:00 GMT-0800 (Pacific Standard Time)";
text = text.Substring(0, text.IndexOf(" GMT"));
DateTime dt;

DateTime.TryParseExact(text, "ddd MMM d yyyy hh:mm:ss", CultureInfo.CurrentCulture, DateTimeStyles.None, out dt);

// this has the output in your desired format.  Note that DateTime variables don't
// have formats, dates only gain a format when you convert to a string so you can't
// store a date in a DateTime variable as a given format
string dateAsText = dt.ToString("yyyy-MM-dd");

Jochen Arndt · Answer 2 · 2016-12-16T01:03:00

Use one of the DateTime Structure (System)[^] conversion methods Parse, ParseExact, TryParse, or TryParseExact to convert the string to a DateTime.

Use an exact method if you know that the input is always in a defined format. The format string for your date

Fri Jan 31 2014 00:00:00 GMT-0800 (Pacific Standard Time)

is (untested) "ddd MMM dd yyyy hh:mm:ss 'GMT'zzz ".

You might strip off the time zone name from the string before parsing.

The DateTime object can then be converted back to a string using the ToString with the required output format ("yyyy-MM-dd").

OriginalGriff · Answer 3 · 2016-12-16T01:09:00

Convert it to a DateTime:

C#

string date = "Fri Jan 31 2014 00:00:00 GMT-0800 (Pacific Standard Time)";
date = date.Substring(0, 25) + date.Substring(28, 3) + ":" + date.Substring(31, 2);
DateTime dt;
if (!DateTime.TryParseExact(date, "ddd MMM dd yyyy hh:mm:ss zzz",CultureInfo.InvariantCulture, DateTimeStyles.AllowWhiteSpaces, out dt))
    {
    // ... report problem
    return;
    }
dt = dt.Date;

How to convert a string date to date format ?

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0