//北京时间字串转时间戳 yyyy-mm-dd hh:mm:ss
__int64 getTimestamp(CString strInputTime)
{
COleVariant vtime(strInputTime);
vtime.ChangeType(VT_DATE);
COleDateTime cOleTime = vtime;
SYSTEMTIME systime;
VariantTimeToSystemTime(cOleTime, &systime);
//时间戳最小值为北京时间: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->时间戳
return timestamp;
}
代码应用:
Csring jcsj;
jcsj.Format(_T(“%I64d”), getTimestamp(csTmp)); // 格式化 13位时间戳