RE: Query > past 10 days not the weekends

From: Lex de Haan <lex.de.haan_at_naturaljoin.nl>
Date: Fri, 24 Sep 2004 20:38:55 +0200
Message-ID: <JFEEIGBIDOCCDALDIPLNAECLCJAA.lex.de.haan@naturaljoin.nl>

which version of Oracle? or do you have a table column containing a last change date?
you don't provide enough information to answer your question ... Kind regards,
Lex.

---

visit http://www.naturaljoin.nl <http://www.naturaljoin.nl>

---

skype me <callto://lexdehaan>

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of bernas, glen Sent: Friday, September 24, 2004 19:34
To: oracle-l_at_freelists.org
Subject: Query > past 10 days not the weekends

How can I create a query that determine a rows that has not been updated for the last 10 business days. That would be the last 2 weeks not including the weekend.

---

Glen Bernas
Database Administrator

        EMC˛
where information lives

Phone:

          Direct: (508) 249-2237
          Ext: 42237

--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Fri Sep 24 2004 - 13:34:36 CDT