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?

On Tuesday, April 25, 2017 17:41:25 Suliman via Digitalmars-d-learn 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?

What types are dealing with here? What is point[1]?

- Jonathan M Davis

On Tuesday, 25 April 2017 at 20:10:02 UTC, Jonathan M Davis wrote:
> On Tuesday, April 25, 2017 17:41:25 Suliman via Digitalmars-d-learn 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?
>
> What types are dealing with here? What is point[1]?
>
> - Jonathan M Davis

writeln(point[1].coerce!string);
writeln(point[1].type);

>std.datetime.DateTime
>std.variant.VariantN!20LU.VariantN

I tried to do:

writeln(DateTime.toISOExtString(DateTime.fromSimpleString(point[1].coerce!string)));

But got error:

Error: function std.datetime.DateTime.toISOExtString () const is not callable using argument types (DateTime)
Error: function database.Database.getSingleTrackInfo no return exp; or assert(0); at end of function

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

On Wednesday, April 26, 2017 04:02:12 Suliman via Digitalmars-d-learn wrote:
> I tried to do:
>
> writeln(DateTime.toISOExtString(DateTime.fromSimpleString(point[1].coerce!
> string)));
>
> But got error:
>
> Error: function std.datetime.DateTime.toISOExtString () const is
> not callable using argument types (DateTime)
> Error: function database.Database.getSingleTrackInfo no return
> exp; or assert(0); at end of function

toISOExtString is a normal member function on DateTime, not a static member function. If point[1].coerce!string is giving you a string in Boost's "simple time" format (e.g. "2016-Jan-04 12:19:17"), then DateTime.fromSimpleString(point[1].coerce!string) will give you a DateTime. Then if you called toISOExtString() on that, e.g.

DateTime dt = DateTime.fromSimpleString(point[1].coerce!string);
string str = dt.toISOExtString();

then the string would be in the ISO extended format (e.g. "2016-01-04T12:19:17"). If you then wanted that in the format "2016-01-04 12:19:17", then you could just replace the 'T' with ' ', e.g.

DateTime dt = DateTime.fromSimpleString(point[1].coerce!string);
string str = dt.toISOExtString().replace("T", " ");

And if you have "2016-01-04 12:19:17", and you want to convert that to the Boost simple time format, you could do

DateTime dt = DateTime.fromISOExtString(str.replace(" ", "T"))
auto simpleStr = dt.toSimpleString();

Hopefully, that helps.

- Jonathan M Davis

On Wednesday, 26 April 2017 at 05:21:32 UTC, Jonathan M Davis wrote:
> On Wednesday, April 26, 2017 04:02:12 Suliman via Digitalmars-d-learn wrote:
>> I tried to do:
>>
>> writeln(DateTime.toISOExtString(DateTime.fromSimpleString(point[1].coerce!
>> string)));
>>
>> But got error:
>>
>> Error: function std.datetime.DateTime.toISOExtString () const is
>> not callable using argument types (DateTime)
>> Error: function database.Database.getSingleTrackInfo no return
>> exp; or assert(0); at end of function
>
> toISOExtString is a normal member function on DateTime, not a static member function. If point[1].coerce!string is giving you a string in Boost's "simple time" format (e.g. "2016-Jan-04 12:19:17"), then DateTime.fromSimpleString(point[1].coerce!string) will give you a DateTime. Then if you called toISOExtString() on that, e.g.
>
> DateTime dt = DateTime.fromSimpleString(point[1].coerce!string);
> string str = dt.toISOExtString();
>
> then the string would be in the ISO extended format (e.g. "2016-01-04T12:19:17"). If you then wanted that in the format "2016-01-04 12:19:17", then you could just replace the 'T' with ' ', e.g.
>
> DateTime dt = DateTime.fromSimpleString(point[1].coerce!string);
> string str = dt.toISOExtString().replace("T", " ");
>
> And if you have "2016-01-04 12:19:17", and you want to convert that to the Boost simple time format, you could do
>
> DateTime dt = DateTime.fromISOExtString(str.replace(" ", "T"))
> auto simpleStr = dt.toSimpleString();
>
> Hopefully, that helps.
>
> - Jonathan M Davis

Thanks! That's work!

But why I can't do it in single line like:
string dt = DateTime.toISOExtString(DateTime.fromSimpleString(point[1].coerce!string));
"Error: function std.datetime.DateTime.toISOExtString () const is not callable using argument types (DateTime)"

And should do:

DateTime dt = DateTime.fromSimpleString(point[1].coerce!string);
string str = dt.toISOExtString();

On Wednesday, April 26, 2017 06:55:01 Suliman via Digitalmars-d-learn wrote:
> Thanks! That's work!
>
> But why I can't do it in single line like:
> string dt =
> DateTime.toISOExtString(DateTime.fromSimpleString(point[1].coerce!string))
> ; "Error: function std.datetime.DateTime.toISOExtString () const is not
> callable using argument types (DateTime)"
>
> And should do:
>
> DateTime dt = DateTime.fromSimpleString(point[1].coerce!string);
> string str = dt.toISOExtString();

You can do it in a single line. I just split it up so that it fit better in the limited line length of an e-mail, and because it was clearer with the types. The problem is that you're calling toISOExtString incorrectly. The from*String functions are static functions, but the to*String functions are normal member functions. You don't pass a DateTime to toISOExtString. You just call it on the DateTime object. So, if you want one line, you end up with something like

auto str = DateTime.fromSimpleString(point[1].coerce!string).
           toISOExtString().replace("T", " ");

- Jonathan M Davis