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: <Jared.Still_at_radisys.com>
Date: Mon, 29 Oct 2001 12:14:12 -0800
Message-ID: <F001.003B78D6.20011029120528@fatcity.com>

Works fine on Solais,

What is the output fom just 'cal 2 2001'?

Jared

                                                                                       
                             
                    "Sherman,                                                          
                             
                    Edward"              To:     Multiple recipients of list ORACLE-L 
<ORACLE-L_at_fatcity.com>        
                    <shermanej_at_ecc       cc:                                           
                             
                    ic.com>              Subject:     RE: Last day of the month unix   
                             
                    Sent by:                                                           
                             
                    root_at_fatcity.c                                                     
                             
                    om                                                                 
                             
                                                                                       
                             
                                                                                       
                             
                    10/29/01 09:50                                                     
                             
                    AM                                                                 
                             
                    Please respond                                                     
                             
                    to ORACLE-L                                                        
                             
                                                                                       
                             
                                                                                       
                             




I was trying to form a similar solution but found it didn't work for Sept. 2001
on HP-UX. Your solution returns "29" on HP-UX Does it work on your UNIX flavor?

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

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).


* * * * * Freedom of Information Act Notice * * * * *
The information in this email is subject to the record protection mandated
by 5 United States Code 552(b)(4) and relevant judicial opinions.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Sherman, Edward
  INET: shermanej_at_eccic.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: 
  INET: Jared.Still_at_radisys.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 - 14:14:12 CST

Original text of this message

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