|
-
SELECT ...
FROM data
WHERE TO_CHAR(date_col,'Dy') NOT IN ('Sat','Sun');
Obviously you'll have to change this if NLS isn't English language.
Looking back - very similar to Pando's!
I work with (near??) a VB developer who's created a table in one of our Oracle Databases that stores the date of every weekend for the next 5 years to help him with a similar problem. Refused to use the 'Dy' solution as he'd have to change his code.
Last edited by JMac; 05-01-2003 at 11:10 AM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote