I used to have this requirement too. I never got to solve it by just using
ksh scripting so ended up getting Oracle to derive the value for me. I guess
this doesn't solve your problem if you don't have an Oracle db running.
#!/bin/ksh
YESTERDAY=`sqlplus -s / <<-EOF
set head off feed off pages 0
select to_char(sysdate-1,'fmDy') from dual;
exit
EOF`
TODAY=`date +\%a`
echo "TODAY is $TODAY YESTERDAY is $YESTERDAY"
Hth,
Ross
-----Original Message-----
Sent: Thursday, 14 November 2002 5:25
To: Multiple recipients of list ORACLE-L
Will someone take pity on this poor VMS'er lost in a unix world??
I'm trying to create a script (ksh) that reads a log file created yesterday.
The log files are created with `date +%a` appended to the end of the log
file name. Last night a log file was created called arc_indexlog.Tue It's
easy enough to get today
TDAY="`date +%a`"
grep -i "ora" /orasrv/ops/maint/logs/arc_indexlog.$TDAY
grep -i "ora" /orasrv/ops/maint/logs/adv_indexlog.$TDAY
but how do I get yesterday in the same format? (i.e., Tue instead of Wed)
I man'd date, but it was no help.
Thanks for any help.
Barb
_____
Do you Yahoo!?
U2 on <http://rd.yahoo.com/launch/mailsig/*http://launch.yahoo.com/u2>
LAUNCH - Exclusive medley & videos from Greatest Hits CD
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ross Collado
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).
