date comparing

  • Thread starter Thread starter Sergey Bogdanov
  • Start date Start date
S

Sergey Bogdanov

Hello,

is there any "lightweight" solutions to compare date/time with certain date.
For example the folowing comparision is true -- 2003-10-10 23:00:00 and
2003-10-10

I've tried to code the folowing but it doesn't work :(

SELECT t.dates, *
FROM t
WHERE Date(t.dates)=#2003-10-10#

thnx,
Sergey
 
You could use:
WHERE DateValue(t.Dates) = #10/10/2003#

Passing the value though a function will mean the engine can't use any index
on this field, so it may be more efficient to use:
WHERE t.Dates >= #10/10/2003# AND t.Dates < #10/11/2003#
 
Back
Top