//获取服务器时间*************************************************
CDatabase m_dbAgent;
m_dbAgent.OpenEx("DSN=EIDSQL;UID=sa;PWD=123456");
CString sql,str;
//CTime tCurTime;
CString strCurTime;
CRecordset *p_rs=new CRecordset; //定义记录集对象指针
p_rs->m_pDatabase=&m_dbAgent; //使数据库指向m_dbAgent
sql = _T("select getdate() as CurTime"); //使用集函数查询对象个数
p_rs->Open(AFX_DB_USE_DEFAULT_TYPE,sql); //获得有效的查询记录集
p_rs->GetFieldValue("CurTime",strCurTime); //取出查询记录集中的数据
p_rs->Close();
m_dbAgent.Close();
delete p_rs;
//shezhi
int nYear = strtol(strCurTime.Left(4),0, 10);
int nMonth = strtol(strCurTime.Mid(5, 2),0, 10);
int nDay = strtol(strCurTime.Mid(8, 2),0, 10);
int nHour = strtol(strCurTime.Mid(11, 2),0, 10);
int nMinute = strtol(strCurTime.Mid(14, 2),0, 10);
int nSecond = strtol(strCurTime.Mid(17, 2),0, 10);
//************************************************************