home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   comp.databases.oracle      Overblown overpriced overengineered SHIT      2,288 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 1,166 of 2,288   
   George Ziniewicz to Solomon Grundy   
   Re: Finding first saturday of month   
   01 Mar 04 17:22:31   
   
   From: zin1@cox.net   
      
   "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?   
      
      This appears to work for me:   
      
          trunc(to_date(year||month),'D')+6 from dual   
      
   zin   
   ---  http://www.zintel.com   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca