SQL date error - TechRepublic
General discussion
January 12, 2002 at 08:31 AM
lord foul

SQL date error

by lord foul . Updated 24 years, 5 months ago

i have an SQL query:
SELECT SUM(TotalHours)
FROM Activity
WHERE Date
BETWEEN #11/10/00# AND #13/10/00#;
the query gives me a result of 256 when upon review of the data the result should be 50 (10 entries of 5 hours each).
Can anyone suggest a theory as to why this error in calculation is happening.
Cheers,
ghost.

This discussion is locked

All Comments