From: fvanbortel@netscape.net   
      
   Mark C. Stock wrote:   
   > "Solomon Grundy"  wrote in message   
   > news:6ad4e542.0402271226.6f8d8e63@posting.google.com...   
   > | Select trunc(sysdate,'MM')   
   > | from dual   
   > | of course gives me the first day of the month, may I ask what the   
   > | query is to find the first saturday of the month?   
   >   
   > check out the NEXT_DAY function   
   >   
   > ;-{ mcs   
   >   
   >   
      
   And be careful with trunc(sysdate):   
   SQL> select trunc(sysdate,'MM') from dual;   
      
   TRUNC(SYSDATE,'   
   ---------------   
   01-FEB-04   
      
   --   
      
   Regards,   
   Frank van Bortel   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)