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