Re: Finding first saturday of month
From: Frank van Bortel <fvanbortel_at_netscape.net>
Date: Sat, 28 Feb 2004 13:10:27 +0100
Message-ID: <c1q0ck$8lk$1_at_news4.tilbu1.nb.home.nl>
01-FEB-04
Date: Sat, 28 Feb 2004 13:10:27 +0100
Message-ID: <c1q0ck$8lk$1_at_news4.tilbu1.nb.home.nl>
Mark C. Stock wrote:
> "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?
>
> 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 BortelReceived on Sat Feb 28 2004 - 13:10:27 CET