Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.oracle -> Re: Finding first saturday of month

Re: Finding first saturday of month

From: Frank van Bortel <fvanbortel_at_netscape.net>
Date: Sat, 28 Feb 2004 21:08:20 +0100
Message-ID: <c1qsck$kqm$1@news3.tilbu1.nb.home.nl>

Mark C. Stock wrote:
> "Frank van Bortel" <fvanbortel_at_netscape.net> wrote in message
> news: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 Bortel
> |
>
> frank,
>
> the OP was intending to use trunc(sysdate,'MM'), which reliably returns the
> first day of the current month -- in what way are you suggesting to be
> careful with trunc(sysdate)?
>
> ;-{ mcs
>
>

Well, for one, I got my wires crossed.
Apologies, forget about previous posting of mine. OP is correct

-- 

Regards,
Frank van Bortel
Received on Sat Feb 28 2004 - 14:08:20 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US