Format Date

[Bernhard Hiller]

Doing some maintenance on an application which I developed a few years ago, I found a small gem:

    public string formatDateMySQL(DateTime date)
    {
        StringBuilder strTmp = new StringBuilder(date.Year.ToString());
        strTmp.Append("-");
        strTmp.Append(date.Month.ToString());
        strTmp.Append("-");
        strTmp.Append(date.Day.ToString());

        return strTmp.ToString();
    }

Yeah, formatting DateTime values works different everywhere, and that's a very "clever" way of coping with that... License: You may use this code according to the CodeProject license. :)

[PIEBALDconsult]

Shirley AppendFormat is the way to go. :laugh:

[Luc Pattyn]

No, but ISO-8601 is IIRC. :)

Luc Pattyn [My Articles] Nil Volentibus Arduum

[ekolis]

Bernhard Hiller wrote:

License: You may use this code according to the CodeProject license. :)

Don't you mean, "License: You must never use this code under penalty of tar-and-feathering"? :)

[Bernhard Hiller]

Just wait a little, and you'll see it becoming the solution for date/time formatting problems with MySQL server in Quick Answers...

[S 53K S]

Is this written in C#? :confused: I guess the more simpler way would be. date.ToString("yyyy-MM-dd") out puts the date as 2012-04-18 or date.ToString("yyyy-M-dd") out puts the date as 2012-4-18 If not C# Kudos to you ;)

Sastry