Re: First day of the month?

SELECT trunc(sysdate,'MM') FROM dual;

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 - 13:44:47 CDT