RE: Last day of the month unix

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

• Sinard Xing <sinardyxing_at_bcs-ach.com.sg>

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