Try this

select to_date('01-FEB-2004','DD-MON-YYYY') + (7 -
to_char(to_date('01-FEB-2004','DD-MON-YYYY'),'D'))
from dual;

_______________________________
r e g/m a h e s h b a s a r k a r


-----Original Message-----
From: Oracle DBA Help [mailto:[Email Address Removed] Saturday, February 28, 2004 1:09 AM
To: LazyDBA.com Discussion
Subject: finding first saturday of the month


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