On 30-10-2014 21:04, Andreas Säger wrote:
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.
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.
--
To unsubscribe e-mail to: [email protected]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
