Re: Last Day Last Month - Query Assistance
From: John Hurley <johnbhurley_at_sbcglobal.net>
Date: Fri, 31 Jul 2009 18:23:15 -0700 (PDT)
Message-ID: <a68c110c-5b25-41c0-8a3f-cb37d704b702_at_h21g2000yqa.googlegroups.com>
On Jul 31, 8:27 pm, master44 <trp..._at_gmail.com> wrote:
Date: Fri, 31 Jul 2009 18:23:15 -0700 (PDT)
Message-ID: <a68c110c-5b25-41c0-8a3f-cb37d704b702_at_h21g2000yqa.googlegroups.com>
On Jul 31, 8:27 pm, master44 <trp..._at_gmail.com> wrote:
snip
> Yeah thats the error I get, but if you run it tomorrow it will return
> 07-31-2009; seems to just fail when the SYSDATE is the 31st. Is there
> a better / easier way to get the last day of last month?
Try using google this question must have been asked and answered thousands of times on the internet. Received on Fri Jul 31 2009 - 20:23:15 CDT