Need Help with PL/SQL
Date: 1996/09/26
Message-ID: <NEWTNews.843740213.31650.atyagi_at_sgeier.wsp>#1/1
Hello Everybody,
I have a table containing a field ship_date. I wish to
select the shipment dates excluding weekends. I only want
data for weekdays. Here is the query I have written.
SELECT EO_SHIPPED.SHIP_DATE, EO_SHIPPED.ORDERNUM
FROM EO_SHIPPED
I tried running subquery seprately but it seems that it is
not liking my comparision with Sat. & Sun and doesn't return
me anything.
I will appreciate any help.
Thanks all.
You can mail me at atyagi_at_mc.xerox.com
or
WHERE ((EO_SHIPPED.SHIP_DATE BETWEEN '14-SEP-96' AND '15-SEP-96')
AND
EO_SHIPPED.SHIP_DATE NOT IN
(SELECT EO_SHIPPED.SHIP_DATE
FROM EO_SHIPPED
WHERE TO_CHAR(EO_SHIPPED.SHIP_DATE,'DAY')='SATURDAY'
OR TO_CHAR(EO_SHIPPED.SHIP_DATE,'DAY')= 'SUNDAY'
));
Amit Tyagi Received on Thu Sep 26 1996 - 00:00:00 CEST