Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Query > past 10 days not the weekends

RE: Query > past 10 days not the weekends

From: Bobak, Mark <Mark.Bobak_at_il.proquest.com>
Date: Fri, 24 Sep 2004 15:04:02 -0400
Message-ID: <4C9B6FDA0B06FE4DAF5918BBF0AD82CF09660EC6@bosmail00.bos.il.pqe>


Off the tope of my head:

select id from your_table where last_change_date > sysdate-14   and to_char(last_change_date,'DAY') not in('SATURDAY','SUNDAY');

-----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 2:43 PM To: oracle-l_at_freelists.org
Subject: RE: Query > past 10 days not the weekends

Yes I do have the last change date.

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

The version of oracle is 9.2.0


Glen Bernas
Database Administrator

        EMC=3DB2 =3D09
where information lives

Phone:=3D20

          Direct: (508) 249-2237
          Ext: 42237


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

From: Lex de Haan [mailto:lex.de.haan_at_naturaljoin.nl]=3D20 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 =3D 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 =3D updated for
the last 10 business days. That would be the last 2 weeks not =3D including the
weekend.


Glen Bernas
Database Administrator

        EMC=3DB2
where information lives

Phone:

          Direct: (508) 249-2237
          Ext: 42237



--

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

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

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US