Yesterday's date - unix question

2002-07-15 Thread Vladimir Barac - posao

Good morning / afternoon / evening...

How to find yesterday's date in unix? Yes, I know how to find it by using
env. variables, sql*plus, redirecting output and so on... But I need pure
unix solution.

Thanks,
Vladimir Barac



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Vladimir Barac - posao
  INET: [EMAIL PROTECTED]

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



RE: Yesterday's date - unix question

2002-07-15 Thread Nicoll, Iain (Calanais)

Vladimir,

Found this on the net (can't recall where though) for touching a file with
yesterdays date.

touch `TZ=GB+24 date +%m%d%H%M%y` filename

You'd need to change the GB to what is appropiate for you and change the
format variables to the format you wish

eg

echo `TZ=GB+24 date +%y%m%d`  to get 020714 yymmdd

HTH

Iain Nicoll

-Original Message-
Sent: Monday, July 15, 2002 10:48 AM
To: Multiple recipients of list ORACLE-L


Good morning / afternoon / evening...

How to find yesterday's date in unix? Yes, I know how to find it by using
env. variables, sql*plus, redirecting output and so on... But I need pure
unix solution.

Thanks,
Vladimir Barac



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Vladimir Barac - posao
  INET: [EMAIL PROTECTED]

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: [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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Nicoll, Iain (Calanais)
  INET: [EMAIL PROTECTED]

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



Re: Yesterday's date - unix question

2002-07-15 Thread Dale

Hi Vladimir

date --date '1 day ago'

Works on my O/S (RedHat Linux) - your O/S may not support this.

Regards
Dale
-
DataBee: Create referentially correct small versions of large Oracle
databases for development and test. http://www.DataBee.com


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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