Re: Vs: Function to calculate weekdays left in a month

If only it were that simple.

That gets me all the days and I am interested in the weekdays only.

Brgds

Jack

On 04/08/2008, Teijo Lallukka <teijo.lallukka_at_edita.fi> wrote:
>
> Hi!
>
> try this, this can help you.
>
> SQL> SELECT SYSDATE,
> LAST_DAY(SYSDATE) "Last",
> LAST_DAY(SYSDATE) - SYSDATE "Days Left"
> FROM DUAL;
>
> SYSDATE Last Days Left
> 1 4.8.2008 8:48:16 31.8.2008 8:48:16 27
>
> -TL
>
>
> -----------------------------------------------------------------------------
> Teijo Lallukka, Oracle DBA
> teijo.lallukka@edita.fi http://www.edita.fi
>
> -----------------------------------------------------------------------------
> www.edilex.fi | www.finlex.fi | www.credita.fi
>
> -----------------------------------------------------------------------------
>
> >>> "Jack van Zanen" <jack_at_vanzanen.com> 4.8.2008 8:45:39 >>>
> 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.
>
>
> Brgds
>
> --
> J.A. van Zanen
>
>

-- 
J.A. van Zanen

--
http://www.freelists.org/webpage/oracle-l