Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
AskSQLTeam
Ask SQLTeam Question
0 Posts |
Posted - 2001-11-21 : 19:41:10
|
tommy writes " QUERY on tomorrows date..SQL windows 32 ver.1.5 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'
My problem is in line 2. I need the sched.start date to be the current date +1 or tomorrows current date.
This would allow me to run the query for the next day, no matter what day it is.
How Do I Do This? Appreciate any help. " |
|
|
|
|