-
Previous Work Date Issue in SLECT
Hello, I need some help...
I have a sql query (Oraacle) wht hase a date staement in the WHERE clause.
I need for it to pull the previous wok day as a criteria in the WHERE.
ie. SELECT *
FROM xxxxxx
WHERE my_date is between
(yestdays workdat and time 00:00:00am) and (yesterdays valid work date 11:59:00)
can any one help, please...
thanks
Kipp
-
trunc(sysdate) -1 to get yesterdays date and go from there
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|