Re: How to fix date format?

[Ali Çehreli via Digitalmars-d-learn]

On 04/25/2017 10:41 AM, Suliman wrote:
I am using mysql native. Date in DB have next format: 2016-11-01 06:19:37
But every tile when I am trying to get it I am getting such format:
2016-Oct-31 15:37:24

I use next code:
writeln(point[1].coerce!string);

Why coerce is forcing format changing? How I can extract result as
without month name between digits or easily convert it in proper data
format?

Here's a silly little code that gets the job done. :)

import std.stdio;

string[string] numeralMonth;

static this() {
    numeralMonth = [ "Jan" : "01", "Feb" : "02", "Mar" : "03", "Apr" : 
"04",
                     "May" : "05", "Jun" : "06", "Jul" : "07", "Aug" : 
"08",
                     "Sep" : "09", "Oct" : "10", "Nov" : "11", "Dec" : 
"12" ];
}

auto goodDateFormat(string str) {
    import std.range : chain, choose;
    if (str.length >= 8) {
        auto key = str[5..8];
        auto numeral = key in numeralMonth;
        if (numeral) {
            import std.string : format;
            return format("%s%s%s", str[0..5], *numeral, str[8..$]);
        }
    }
    return str;
}

void main() {
    writeln(goodDateFormat("2016-Oct-31 15:37:24"));
}

Ali