FireGeek wrote:
> Thanks everyone for the help.
>
> SELECT LAST_DAY(ADD_MONTHS(SYSDATE, 2))+1
>
> This seems to be the best solution.
>
> One more question:
> Is there a way to determine what week a particular date is?
> Considering a calendar year is 52 weeks, I am looking at finding what
> week say 07/10/2006 is (which would be week 28).
>
> Any ideas?
>
> THANKS AGAIN!!!
>
> FireGeek
Not unless you write your own as different organizations have
different definitions of what "Week 1" means.
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Thu Jul 13 2006 - 16:14:42 CDT
