//時(shí)間戳轉(zhuǎn)北京時(shí)間字串
CString getLocalDate(__int64 timestamp)
{
    timestamp += 28800;//GTM偏移8個(gè)時(shí)區(qū)得到北京時(shí)間
    tm p;
    gmtime_s(&p, &timestamp);
    char s[80];
    strftime(s, 80, "%Y-%m-%d %H:%M:%S", &p);
    return CString(s);
}

//北京時(shí)間字串轉(zhuǎn)時(shí)間戳
__int64 getTimestamp(CString strInputTime)
{
    COleVariant vtime(strInputTime);
    vtime.ChangeType(VT_DATE);
    COleDateTime cOleTime = vtime;
    SYSTEMTIME systime;
    VariantTimeToSystemTime(cOleTime, &systime);
    //時(shí)間戳最小值為北京時(shí)間:1970-01-01 08:00:00
    if (systime.wYear <= 1970 && systime.wMonth <= 1 && systime.wDay <= 1 && systime.wHour <= 7 && systime.wMinute <= 59 && systime.wSecond <= 59)
        return 0;
    CTime cTimeFromDB(systime);
    __int64 timestamp = cTimeFromDB.GetTime();//CTime->時(shí)間戳
    return timestamp;
}