VC++中ADO方式操作数据库之有关“datetime”字段的操作

直接上代码：

void CADOConDlg::OnButton1() 
{
	// TODO: Add your control notification handler code here
	HRESULT hr;
	CString strSql;
	_ConnectionPtr m_pConnection;
	_RecordsetPtr m_pRecordset;
	try
	{
		//create the SQL service object 
		hr = m_pConnection.CreateInstance(__uuidof(Connection));
		ASSERT( SUCCEEDED(hr) );
		strSql.Format("%s","Provider=SQLOLEDB;server=xxx;database=xxx;UID=xxx;PWD=xxx");
		m_pConnection->ConnectionString = (_bstr_t)strSql;
		hr = m_pConnection->Open("","","",adConnectUnspecified);
		ASSERT( SUCCEEDED(hr) );
		//create the record set object for write
		hr = m_pRecordset.CreateInstance(__uuidof(Recordset));
		ASSERT( SUCCEEDED(hr) );

		CString strCurrentTime;
		strSql.Format(_T("select * from 。。。='。。' "));
		m_pRecordset->raw_Close();
		m_pRecordset->CursorLocat