query where date field = current_date +1

[jcp2mill]

Hi I have a table of tv recordings where each recording has a title id date to be recorded and watched, I want to be able to filter these so that I can look at recordings that are due to take place tommorow

I’ve tried

Select * From “Mytable” Where “DAtefield” = CURRENT_DAY + 1

Select * From “Mytable” Where “DAtefield” = CURRENT_DAY + 1 DAY

and

Select * From “Mytable” Where “DAtefield” = SYSDATE + 1

none of them work anyone have ny ideas of why I also tried DATE_DIFF and still no luck.

Thanks

[Ratslinger]

Which database you use makes a great difference as to the answer. If this is an embedded DB, then it is HSQL v1.8 otherwise please specify which you are using.

[librebel]

Hello jcp2mill, you could try:

SELECT * FROM "Mytable" WHERE DATEDIFF('day', TODAY,  "DAtefield") = 1