WHERE constants for DateTime

From: Piedro Mazolo (pmazolo_at_hotmail.com)
Date: 06/18/04


Date: Fri, 18 Jun 2004 00:50:35 +0200

I am working with an Access Database (using SQL from Delphi).

I send something like

SELECT *

FROM xxxx

WHERE THEDATE >= #01/12/2004#

and this works, and also seems to be an SQL standard for date constants that
is not depending on country etc like other date things.

However, THEDATE also contains time (specified as General Date in Access),
and I was hoping to use something like

WHERE THEDATE >= #01/12/2004 23:05:00#

in Delphi, but no format for the time I have tried here works. Any
suggestions what to do to filter on time info too?

Rgds

Piedro Mazolo