select to_char(<datefield>,'YYYY-MM-DD') from <table>
where to_char(<datefield>,'DD') <'08' and to_char(<datefield>,'Day')
='Saturday ';

Don't forget the space after the word Saturday.




"Oracle DBA Help"
<[Email Address Removed] To: "LazyDBA.com Discussion" <[Email Address Removed]
com> cc: (bcc: Kurt Verstraeten/BRU/MASTERCARD)
Subject: finding first saturday of the month
02/27/2004 08:39
PM






What query can I run to find the first saturday of the month, and only the
first saturday of the month?





-----------------------------------------
CONFIDENTIALITY NOTICE
This E-mail message and any documents which accompany it are intended only for the use of the individual or entity to which addressed, and may contain information that is privileged, confidential or exempt from disclosure under applicable law. If the reader is not the intended recipient, any disclosure, distribution or other use of this E-mail message is prohibited. If you have received this E-mail message in error, please delete and notify the sender immediately. Thank you.

Oracle LazyDBA home page