Date manipulation

users
#1

I want to set a date range in a query to be between TODAY -10 Days and TODAY + 10 days. Is there a simple way to do this?

Regards

Peter Goggin

#2

For an embedded HSQL database the query goes like this:

SELECT * FROM "Your Table" WHERE DATEDIFF('day', CURRENT_DATE, "Date Field")
BETWEEN -10 AND 10

Replace the double quoted names with the actual names of your table and
field.

#3

Quicker should be (if an index exists on "Date Field":

select *
from "Your Table"
WHERE "Date Field" BETWEEN
   DATEADD('day', -10, CURRENT_DATE and DATEADD('day', +10, CURRENT_DATE)

Because with this query an index will be used, and with the datadiff-query, no index will be used.