RE: Query > past 10 days not the weekends
- From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxxxxx>
- To: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxxxxx>, <bernas_glen@xxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 24 Sep 2004 15:17:16 -0400
Whoops, my '>' should have been a '<'.
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Bobak, Mark
Sent: Friday, September 24, 2004 3:04 PM
To: bernas_glen@xxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: RE: Query > past 10 days not the weekends
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');
--
//www.freelists.org/webpage/oracle-l
Other related posts:
