CTime m_vTime,year,month,day;year = m_vTime.GetYear();
month = m_vTime.GetMonth();
day = m_vTime.GetDay();现在能得到Time 的值,数据库oracle中有个字段名是CREATETIME, 类型是DATE型 _bstr_t bstrSqlCountByDay = _T(" select count(*) COUNTDATA from sbwf_task_instance where TASK_TARGET = '#生成者#' AND CREATETIME > to_date('2005-3-29 00:00:00') AND CREATETIME < to_date('2005-3-29 23:59:59')" );这条语句能查到2005年3月29日的记录数,请问如何把2005-3-29 换成 我已经取得的Time值??
month = m_vTime.GetMonth();
day = m_vTime.GetDay();现在能得到Time 的值,数据库oracle中有个字段名是CREATETIME, 类型是DATE型 _bstr_t bstrSqlCountByDay = _T(" select count(*) COUNTDATA from sbwf_task_instance where TASK_TARGET = '#生成者#' AND CREATETIME > to_date('2005-3-29 00:00:00') AND CREATETIME < to_date('2005-3-29 23:59:59')" );这条语句能查到2005年3月29日的记录数,请问如何把2005-3-29 换成 我已经取得的Time值??
TCHAR szData[64];
wsprintf(szData,_T("%d-%d-%d"),m_vTime.GetYear(),m_vTime.GetMonth(),m_vTime.GetDay()); TCHAR szSQL[1024];
wsprintf(szSQL,_T(" select count(*) COUNTDATA from sbwf_task_instance where TASK_TARGET = '#生成者#' AND CREATETIME > to_date('%s 00:00:00') AND CREATETIME < to_date('%s 23:59:59')"),szData,szData);
_bstr_t bstrSqlCountByDay = szSQL;