Re: Finding first saturday of month

"Solomon Grundy" <logicjello_at_netscape.net> wrote in message news:6ad4e542.0402271226.6f8d8e63_at_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 Received on Mon Mar 01 2004 - 19:22:31 CST