October 4th, 2000, 07:13 PM
I am trying to construct a query string that will return a result set between two dates.
something along the lines of:
select * from milestone where dueDate > 2000-08-01 && dueDate < 2001-08-01;
it works when I compart a date to current date :
select * from milestone where dueDate > CURRENT_DATE;
but not the first, I even tried using BETWEEN...AND; that returned an empty result set as well
Any help out there?
October 4th, 2000, 10:31 PM
You have to put single quotes around your dates. This worked for me
select * from test where my_date between '1999-1-1' and '2001-1-1';