sqlserver 中时间转变为coledatetime，再到systemtime

工作中经常用到时间互转，下面说的是VC中时间转换。

以下是代码片段：

_variant_t vtBegainTime = _record->GetCollect(_T("timeInSql"));

 CString strBegainTime = _T("");

 COleDateTime oleTimeGet;    
 SYSTEMTIME sysTimeGet; 
 oleTimeGet=(COleDateTime)vtBegainTime;  
 VariantTimeToSystemTime(oleTimeGet, &sysTimeGet);  
 strBegainTime.Format(_T("%04d-%02d-%02d %02d:%02d:%02d"), sysTimeGet.wYear, sysTimeGet.wMonth, sysTimeGet.wDay,

 sysTimeGet.wHour, sysTimeGet.wMinute, sysTimeGet.wSecond);