Re: String to FILETIME

From:

Hans-J. Ude <news@s237965939.online.de>

Newsgroups:

microsoft.public.vc.mfc

Date:

Wed, 28 Jan 2009 11:14:33 +0100

Message-ID:

<gfb0o4po27a8t26a5aenpu3eoh39psldfo@4ax.com>

"Tom Serface" <tom@nospam.camaswood.com> wrote:

Here is a routine I used to convert a date I had:

CTime MyApp::ConvertUTCDateTime(LPCTSTR szDateTime)
{
    // Parse the start date from format 2008-04-03T16:03:52+08:00
    CString cs = szDateTime;
    int i = cs.Find(_T('T'));
    if(i != -1) {
         CString csDate = cs.Left(i);
         CString csTime = cs.Mid(i+1);
         i = csTime.ReverseFind(_T('+'));
         if(i == -1)
              i = csTime.ReverseFind(_T('-'));
        else {
              // Use GMT?
              csTime = csTime.Left(i);
         }
         cs.Format(_T("%s %s"),csDate,csTime);
         COleDateTime oTime;
         if(oTime.ParseDateTime(cs)) {
              SYSTEMTIME sTime;
              oTime.GetAsSystemTime(sTime);
              return CTime(sTime);
         }
    }
    return CTime::GetCurrentTime();
}

In the old days we'd simply written

int year, month, day;
int hour, minute, second;
int tz_hour, tz_minute;
char *p = "2009-01-23T11:57:26+06:00";

sscanf(p, "%d-%d-%dT%d:%d:%d%d:%d",
    &year, &month, &day,
    &hour, &minute, &second,
    &tz_hour, &tz_minute );

That works with positive as negative TZ values as well. I'm not sure
about an official definition of that string format. If there are
differences it would fail. sscanf() is deprecated and there is also
unicode these days, so sscanf_s() or swscanf_s() would be the choice
today.

Hans