Question: I have a SQL database, one of which is a field: purchase time is a short-term type, no problem in querying this field under SQL, but the normal result cannot be returned with VB ADO. For example, I use the SQL statement Select * from Table 1 WHERE to return time> = '2000-10-12', return all records, regardless of the condition date, if the <'2000-10-12' No records return, don't you know what?
In the query, use the following statement is correct: SELECT * FORM Table 1 WHERE COMPUS> = # 2000-10-12 # The statement when query is best to use long format time, otherwise the "2000" annual issue will appear. I hope the answer will help you.