Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Last day of the month unix

RE: Last day of the month unix

From: Bellows, Bambi <BBellows_at_usg.com>
Date: Mon, 29 Oct 2001 09:07:15 -0800
Message-ID: <F001.003B71B9.20011029084022@fatcity.com>

Well, you can do date functions in Unix. The date function is date. It's not normal, because Unix Commands are supposed to be cryptic.

But, you could do the following. You'll want to test it because no to Unii are the same...

cal|tail -2|head -1|awk '{print $NF}' (last day of current month) cal 2 2001|tail -2|head -1|awk '{print $NF}' (last day of February 2001)

HTH,
Bambi.

-----Original Message-----
Sent: Monday, October 29, 2001 8:55 AM
To: Multiple recipients of list ORACLE-L

> Hi,
>
> Is there any function that can display out "last day of the month" for
> example
> lastday(Oct,2001) return me 31
> Or a variable that store this value.
>
> Is Date an object in unix ?

Check the Date::Manip package. The simplest way is to check for

    UnixDate( 'tommorrow', '%d') == 1 ? 'last day of month', 'not last day';

--
Steven Lembark                               2930 W. Palmer
Workhorse Computing                       Chicago, IL 60647
                                            +1 800 762 1582
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Steven Lembark
  INET: lembark_at_wrkhors.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: Bellows, Bambi
  INET: BBellows_at_usg.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 Mon Oct 29 2001 - 11:07:15 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US