First day of the month?

From: Doug O'Leary <dkoleary_at_mediaone.net>
Date: Thu, 28 Jun 2001 01:20:46 GMT
Message-ID: <MPG.15a4439f8e8cfd769897a5@news.randori.com>

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 Wed Jun 27 2001 - 20:20:46 CDT