Re: Finding first saturday of month

"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 Received on Sat Feb 28 2004 - 13:17:13 CET