I have software with oracle data base... I need to write a query that displays all my workorders from tomorrows date only.
My query looks like this:
WHERE WORKORDER.STATUS = 'WAPPR' AND WORKORDER.SCHEDSTART = '2001-11-14' AND
WORKORDER.WOEQ9 = 'SEACS00'
I need the sched.start date to be the current date +1 or tomorrows current date.
How Do I Do This?
Appreciate any help.
My query looks like this:
WHERE WORKORDER.STATUS = 'WAPPR' AND WORKORDER.SCHEDSTART = '2001-11-14' AND
WORKORDER.WOEQ9 = 'SEACS00'
I need the sched.start date to be the current date +1 or tomorrows current date.
How Do I Do This?
Appreciate any help.
