Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

C# DateTime parse short string ("MMMyy")

I have a string which contains date and has a format of "MMMyy". How would it be possible to do that?
Sample:

string date = "MAY09";
DateTime a = DateTime.Parse("MAY09"); //Gives "2012.05.09 00:00:00"
DateTime b = DateTime.ParseExact("MAY09", "MMMyy", null); //Gives error
DateTime c = Convert.ToDateTime("MAY09"); //Gives "2012.05.09 00:00:00"

I need "2009-05-01"
like image 754
JNM Avatar asked Jul 26 '12 06:07

JNM


People also ask

What C is used for?

C programming language is a machine-independent programming language that is mainly used to create many types of applications and operating systems such as Windows, and other complicated programs such as the Oracle database, Git, Python interpreter, and games and is considered a programming foundation in the process of ...

What is the full name of C?

In the real sense it has no meaning or full form. It was developed by Dennis Ritchie and Ken Thompson at AT&T bell Lab. First, they used to call it as B language then later they made some improvement into it and renamed it as C and its superscript as C++ which was invented by Dr.

Is C language easy?

C is a general-purpose language that most programmers learn before moving on to more complex languages. From Unix and Windows to Tic Tac Toe and Photoshop, several of the most commonly used applications today have been built on C. It is easy to learn because: A simple syntax with only 32 keywords.

What is C in C language?

What is C? C is a general-purpose programming language created by Dennis Ritchie at the Bell Laboratories in 1972. It is a very popular language, despite being old. C is strongly associated with UNIX, as it was developed to write the UNIX operating system.


2 Answers

Specify invariant culture fore the third parameter instead of null:

DateTime b = DateTime.ParseExact("MAY09", "MMMyy", CultureInfo.InvariantCulture);
like image 170
Kirill Polishchuk Avatar answered Sep 19 '22 21:09

Kirill Polishchuk


The second one is what you want - other than using the right culture. null says to use the date/time format information from the current culture - which will fail if it's not an English culture. (It's not clear from your user profile where you are, but presumably not in an English culture?)

Specifying the invariant culture is an easy way of getting English month/day names:

using System;
using System.Globalization;

class Test
{
    static void Main()
    {
        string text = "MAY09";
        string pattern = "MMMyy";
        var culture = CultureInfo.InvariantCulture;
        DateTime value = DateTime.ParseExact(text, pattern, culture);
        Console.WriteLine(value.ToString("yyyy-MM-dd", culture));
    }
}
like image 28
Jon Skeet Avatar answered Sep 21 '22 21:09

Jon Skeet