Re: Last Day Last Month - Query Assistance

From: joel garry <>
Date: Fri, 31 Jul 2009 17:07:02 -0700 (PDT)
Message-ID: <>

On Jul 31, 4:36 pm, master44 <> wrote:
> I put a query together to pull the last day of last month that has
> worked fine for the last 2 months, but suddenly failed today now that
> the date is the 31st of the month:
> What am I doing wrong??
> Eunning this against a Oracle 10G database, sorry don't know the exact
> version.

select SYSDATE-numtoyminterval(1, 'MONTH') from dual

ERROR at line 1:
ORA-01839: date not valid for month specified

Seems Oracle doesn't like some implicit conversion subtracting from sysdate here.


-- is bogus.
Received on Fri Jul 31 2009 - 19:07:02 CDT

Original text of this message