Re: CTime getting skewed due to regional settings

I am writing to a DateTime field but via a dynamically constructed SQL
statement:

String sql("INSERT INTO WorkflowAction (ID, WorkflowID, FilterID, SeqNo,
ReceiveByDate, Path ) VALUES(");

sql.append(ToString<KeyId>(req->GetKey()));
sql.append(1,',');
sql.append(ToString<KeyId>(workflow->GetKey()));
sql.append(1,',');
sql.append(ToString<ActionID>(eRequest));
sql.append(",1,",3); // seq # - request always first
sql.append(1,'\'');
sql.append( req->GetReceiveByDate().ToDBString());
sql.append(1,'\'');
sql.append(1,',');
sql.append(1,'\'');
sql.append( req->GetDocument()->GetPath().c_str());
sql.append(1,'\'');
sql.append(")");

conn->ExecuteSQL(sql.c_str());

But what has changed now is I call ToDBString, which uses the following

String DateTime::ToDBString()const
{
    struct tm timeinfo;
    char timebuf[26];

    memset(timebuf,0,26);

    errno_t errNo = localtime_s(&timeinfo, &mRawTime);
    assert(errNo == 0 );

    strftime(timebuf,26,"%Y-%m-%d ",&timeinfo);
    return timebuf;

}

as opposed to previously using the ToString function which used the following

    strftime(timebuf,26,"%x",&timeinfo);

The ToString is still used within the presentation layer and dates are
correctly diplayed in host locale, but now when i write the dates they are
locale neutral, this allows them to then be interpreted correctly relative to
the locale when read back in.

Hope this makes sense?

"Giovanni Dicanio" wrote: