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.5I 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." |
|
|
|
|
|
QUERY on tomorrows date..SQL windows 32 ver.1.5