Re: Finding first saturday of month

logicjello_at_netscape.net (Solomon Grundy) 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?

Try this
select trunc(sysdate,'mm')+(7- to_char(trunc(sysdate,'mm'),'d')) first_sat  from dual;

Replace sysdate with any date. Received on Tue Mar 02 2004 - 22:08:06 CET