RE: Query > past 10 days not the weekends
- From: "Lex de Haan" <lex.de.haan@xxxxxxxxxxxxxx>
- To: <bernas_glen@xxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 24 Sep 2004 20:38:55 +0200
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of bernas, glen
Sent: Friday, September 24, 2004 19:34
To: oracle-l@xxxxxxxxxxxxx
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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
