How to query data for time in ACCESS

xiaoxiao2021-03-18  226

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.

转载请注明原文地址:https://www.9cbs.com/read-129824.html

New Post(0)