Re: Function to calculate weekdays left in a month
From: Jared Still <jkstill_at_gmail.com>
Date: Mon, 4 Aug 2008 13:59:31 -0700
Message-ID: <bf46380808041359o196f7e93ha58ba2ea5af5aae4@mail.gmail.com>
Date: Mon, 4 Aug 2008 13:59:31 -0700
Message-ID: <bf46380808041359o196f7e93ha58ba2ea5af5aae4@mail.gmail.com>
On Sun, Aug 3, 2008 at 10:45 PM, Jack van Zanen <jack_at_vanzanen.com> wrote:
> Hi All,
>
> I am not a programmer and before I spend a lot of time on some PL/SQL to do
> this I would just like to double check if anybody on this list has created
> such a function/proc already.
>
>
This works:
select last_day(trunc(sysdate+1)) - trunc(sysdate) from dual
-- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist -- http://www.freelists.org/webpage/oracle-lReceived on Mon Aug 04 2008 - 15:59:31 CDT