Re: Finding first saturday of month

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Fri, 27 Feb 2004 15:31:10 -0500
Message-ID: <3u6dneap7qSJNKLd4p2dnA_at_comcast.com>

"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 Received on Fri Feb 27 2004 - 21:31:10 CET

This message: [ Message body ]
Next message: Renvaldas Mackevicius: "Re: MERGE bug?"
Previous message: David Morse: "Re: Java Stored Procedures"
Next in thread: Frank van Bortel: "Re: Finding first saturday of month"
Reply: Mark C. Stock: "Re: Finding first saturday of month"
Reply: Frank van Bortel: "Re: Finding first saturday of month"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message