RE: Query > past 10 days not the weekends

From: bernas, glen <bernas_glen_at_emc.com>
Date: Fri, 24 Sep 2004 14:42:34 -0400
Message-ID: <7FAAE4DE7248554ABD8C69DD4A18289B0539AE7B@srnamath-bkp.lss.emc.com>

Yes I do have the last change date.

I have problems determining 10 business days in a query. I can't go = back 2
weeks because it may contain a weekend.

The version of oracle is 9.2.0

---

Glen Bernas
Database Administrator

        EMC=B2 =09
where information lives

Phone:=20

          Direct: (508) 249-2237
          Ext: 42237

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

From: Lex de Haan [mailto:lex.de.haan_at_naturaljoin.nl]=20 Sent: Friday, September 24, 2004 2:39 PM To: bernas_glen_at_emc.com; oracle-l_at_freelists.org Subject: RE: Query > past 10 days not the weekends

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=B2
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:38:20 CDT