新手问题:变量转换

[18320606]

CString mTime;
mTime.Format("%d-%d-%d %d:%d:%d",
m_NowDate.GetYear(), m_NowDate.GetMonth(), m_NowDate.GetDay(),
m_NowTime.GetHour(), m_NowTime.GetMinute(), m_NowTime.GetSecond());
在我数据表中的字段为日期类型,就是上面的格式,请问我该如何转换?
.......
pSet->PutCollect("MyDate",???????);//这句该怎么写
......

还有,_variant_t到底是用来干什么的,它是怎么转换数据的,我不会用

[handsomerun]

CString mTime;
mTime.Format("%d-%d-%d %d:%d:%d",
m_NowDate.GetYear(), m_NowDate.GetMonth(), m_NowDate.GetDay(),
m_NowTime.GetHour(), m_NowTime.GetMinute(), m_NowTime.GetSecond());

CString str；
str.format("#%s#",mTime);

pSet->PutCollect("MyDate",str);//这句该怎么写

[handsomerun]

晕，注释也拷来了

[balloy]

使用_variant_t (vt = VT_DATE)

eg:

_variant_t _GetCurrentTime()
{
_variant_t vTime;
SYSTEMTIME time;
GetLocalTime(&time);
vTime.vt = VT_DATE;
SystemTimeToVariantTime(&time, &(vTime.date));
return vTime;
}