ACCESS time query ...

ozms123

I have a time field in my access
Data type is date / time
How do I write SQL statements in my ADO queries ???
And the query date type entered by my edit box is CString
So how do you combine them for querying?
Thank you

ozms123

Isn't it so troublesome / .1 / ...?

ozms123

Did I not explain it?

qymmonkey

CString strSQL;
strSQL.Format ("Select * From TableName where TableName.DateType = # 2017-1-4 #");

qymmonkey

The example assumes that there is a table named TableName in the database.
The TableName table has a field of type DateType,

ghostxp16

strSQL.Format ("SELECT * FROM table WHERE column = '% s'", CString)

ozms123

I entered it as CString!
Tip Data does not match
My database is date type!
The string can't be found at all.
For example: I entered 2002-2-1 and it was wrong!
Do you have to convert ?!

ghostxp16

CString strTime = "2002-2-1";
CString strSQL;
strSQL.Foramt (SELECT * FROM table (table name) WHERE column (column name) = '% s' ", strTime);
pRs-> Open ((_ bstr_t) strSQL, ...);

ozms123

It is exactly what I have done
Error message:
Standard expression city data types do not match!
????
I think you checked it according to the string

ozms123

Is that right?