RE: Query > past 10 days not the weekends

Whoops, my '>' should have been a '<'.

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Bobak, Mark Sent: Friday, September 24, 2004 3:04 PM To: bernas_glen_at_emc.com; oracle-l_at_freelists.org 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');

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