RE: How to calculate Last and First Day of Month?

From: Weaver, Walt <wweaver_at_rightnow.com>
Date: Wed, 23 Jan 2002 14:07:20 -0800
Message-ID: <F001.003F9383.20020123135529@fatcity.com>

select last_day(add_months(sysdate,-1)) from dual;

-----Original Message-----
Sent: Wednesday, January 23, 2002 2:38 PM To: Multiple recipients of list ORACLE-L

It is the 1st. I've already got quick help on that...

thanks

• Charlie Mengler <charliem_at_mwh.com> wrote:
  > I would have thought that the "first day of the
  > month"
  > is ALWAYS the 1st, as in 1 (ONE)!
  >
  > Please explain why it needs to be calculated or
  > could be a value other than ONE.
  >
  > >
  > > >>> stant_98_at_yahoo.com 01/23/02 10:35AM >>>
  > > Hey guys,
  > >
  > > I know this is propablby easy, but I'm a bit
  > > overwhelmed here this week. Can you please tell me
  > how
  > > to get first and last days of the month given
  > SYSDATE?
  > >
  > > thanks a lot
  > >
  > > Regards
  > >
  > --
  > Please see the official ORACLE-L FAQ:
  > http://www.orafaq.com
  > --
  > Author: Charlie Mengler
  > INET: charliem_at_mwh.com
  >
  > Fat City Network Services -- (858) 538-5051 FAX:
  > (858) 538-5051
  > San Diego, California -- Public Internet
  > access / Mailing Lists
  >

  ---

  
  > To REMOVE yourself from this mailing list, send an
  > E-Mail message
  > to: ListGuru_at_fatcity.com (note EXACT spelling of
  > 'ListGuru') and in
  > the message BODY, include a line containing: UNSUB
  > ORACLE-L
  > (or the name of mailing list you want to be removed
  > from). You may
  > also send the HELP command for other information
  > (like subscribing).
  

  ---

Do You Yahoo!?
Send FREE video emails in Yahoo! Mail!
http://promo.yahoo.com/videomail/

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Viktor
  INET: stant_98_at_yahoo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Weaver, Walt
  INET: wweaver_at_rightnow.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Wed Jan 23 2002 - 16:07:20 CST