SQL query by time in delphiaccess

Although the function of the Access database is poor, it is very convenient to save a small amount of data, as is true in delphi, when querying, you must use the date or time as the query condition. access is somewhat special. Select * fromtablewherestartime #2014-02-202: 12: 00 # note two points: 1. Date and Time

Although the function of the Access database is poor, it is very convenient to save a small amount of data, as is true in delphi, when querying, you must use the date or time as the query condition. access is somewhat special. Select * from table where startime #2014-02-20 2: 12: 00 # note two points: 1. Date and Time

Although the function of the Access database is poor, it is very convenient to save a small amount of data, as is true in delphi, when querying, you must use the date or time as the query condition. access is somewhat special.

Select * from table where startime> #2014-02-20 2: 12: 00 #

Note:

1. Add at both ends of date and time #

2. The delimiter colon in the middle of the time must be two consecutive characters, because in delphi, the colon represents a parameter, and the colon represents a non-parameter.