Re: Finding first saturday of month
From: George Ziniewicz <zin1_at_cox.net>
Date: Mon, 1 Mar 2004 17:22:31 -0800
Message-ID: <ZoQ0c.5727$506.3314_at_fed1read05>
Date: Mon, 1 Mar 2004 17:22:31 -0800
Message-ID: <ZoQ0c.5727$506.3314_at_fed1read05>
"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?
This appears to work for me:
trunc(to_date(year||month),'D')+6 from dual
zin
--- http://www.zintel.com
Received on Tue Mar 02 2004 - 02:22:31 CET