Posted on 2003-03-02
Hi, I am writing a program using Visual C++.
I need to make a connection to the database. I did it using the below code...
pCommand->ActiveConnection = m_pConn;
CString sSQL; sSQL.Format(
"SELECT * FROM ConstructionSequence "
"WHERE StartDate>'%s' ",
pCommand->CommandText = (_bstr_t) sSQL;
I have this problem, I am currectly using StartDate (a field in the database) as a text format. This code works only when StartDate is in Text format but not when it is in Date/Time format. If I were to change StartDate from text format to date/time format, how should I change the code
Please advice~ Thanks