Re: Last Day Last Month - Query Assistance
From: joel garry <joel-garry_at_home.com>
Date: Fri, 31 Jul 2009 17:07:02 -0700 (PDT)
Message-ID: <b347c330-3213-42d2-9895-695f8f696b14_at_i8g2000pro.googlegroups.com>
On Jul 31, 4:36 pm, master44 <trp..._at_gmail.com> 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:
>
> SELECT TO_DATE(TO_CHAR(LAST_DAY(SYSDATE + numtoyminterval(-1,
> 'MONTH')), 'YYYY-MM-DD'), 'YYYY-MM-DD') FROM DUAL
>
> What am I doing wrong??
>
> Eunning this against a Oracle 10G database, sorry don't know the exact
> version.
Date: Fri, 31 Jul 2009 17:07:02 -0700 (PDT)
Message-ID: <b347c330-3213-42d2-9895-695f8f696b14_at_i8g2000pro.googlegroups.com>
On Jul 31, 4:36 pm, master44 <trp..._at_gmail.com> 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:
>
> SELECT TO_DATE(TO_CHAR(LAST_DAY(SYSDATE + numtoyminterval(-1,
> 'MONTH')), 'YYYY-MM-DD'), 'YYYY-MM-DD') FROM DUAL
>
> 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.
jg
-- _at_home.com is bogus. http://pwnie-awards.org/2009/Received on Fri Jul 31 2009 - 19:07:02 CDT