Re: First day of the month?

From: Stephen Bell <stephen.bell_at_cgi.ca>
Date: Thu, 28 Jun 2001 07:50:46 -0400
Message-ID: <3B3B1A15.572594BD@cgi.ca>

Hi Doug,

What about

SQL> select last_day(sysdate)+1 from dual;

LAST_DAY(

---

01-JUL-01 Steve

Doug O'Leary wrote:

> Hey;
>
> One of our dbas is running a script for a manager by manually updating
> the date in the script as the first of the month. I asked him why he
> didn't have the system do that for him, then send the thing via email to
> the manager in html format. He asked how to do that - id the first day
> of the month, that is; the rest I'll have to script for him.
>
> My first pass at doing that via sql, although functional, was the height
> of ugly. The second attempt works; however, I realize it'll have a
> problem every march 1st and 2nd. The third attempt, I believe hits the
> solution right on the head; I'm wondering, though, if anyone's got any
> cleaner way to do it.
>
> I'd appreciate any feedback. Thanks for your time.
>
> Doug
>
> 2nd attempt:
>
> SQL> select last_day(sysdate - 31)+1 "Date" from dual;
>
> Date
> --------
> 06/01/01
>
> 3rd attempt:
>
> SQL> select last_day(add_months(sysdate,-1))+1 "Date" from dual;
>
> Date
> --------
> 06/01/01
>
> --
> -------------------
> Douglas K. O'Leary
> Senior System Administrator
> dkoleary_at_mediaone.net
Received on Thu Jun 28 2001 - 06:50:46 CDT