Question

vc中如何将日期时间存入数据库

Answer 1

CString strBirthdayDate,strEntryDate;

strBirthdayDate.Format("%04d%02d%02d",m_BirthdayDate.GetYear(),m_BirthdayDate.GetMonth(),m_BirthdayDate.GetDay()); //m_BirthdayDate是时间控件
strEntryDate.Format("%04d%02d%02d",m_EntryDate.GetYear(),m_EntryDate.GetMonth(),m_EntryDate.GetDay());

//将增加的员工信息写入数据库
CString sql;
sql.Format("insert into staffmng values('%s','%s','%s','%s','%s','%s')",m_strID,m_strName,strSex,strBirthdayDate,strWorkState,strEntryDate);
m_pDoc->m_Odbc.ExecSql(sql);