[Lazarus] Microsft Access Date Select statment
Werner Pamler
werner.pamler at freenet.de
Sat Mar 25 00:38:52 CET 2023
Am 24.03.2023 um 21:48 schrieb Larry Dalton via lazarus:
> No matter how I format the beginning and ending dates, it doesn't
> work. If I format the dates in quoted strings ('20230101') or any
> variation, I get the incompatible types errors.
Enclose the date/time by '#', put the date parts in year/month/day order
and separate them by slashes:
Query.SQL.Add('SELECT * FROM Events WHERE (StartTime >=
#2019/01/15#) AND (StartTime < #2019/01/16#)');
But using query parameters is always the better way.
More information about the lazarus
mailing list