Return-Path: Received: from ensim.rackshack.net (root@localhost) by orafaq.net (8.11.6/8.11.6) with ESMTP id gBN95dd32639 for ; Mon, 23 Dec 2002 03:05:39 -0600 X-ClientAddr: 209.68.248.164 Received: from newsfeed.cts.com (newsfeed.cts.com [209.68.248.164]) by ensim.rackshack.net (8.11.6/8.11.6) with ESMTP id gBN95dc32634 for ; Mon, 23 Dec 2002 03:05:39 -0600 Received: from fatcity.UUCP (uucp@localhost) by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id VAA23938; Sun, 22 Dec 2002 21:45:21 -0800 (PST) Received: by fatcity.com (26-Feb-2001/v1.0g-b72/bab) via UUCP id 00520FCE; Sun, 22 Dec 2002 21:08:37 -0800 Message-ID: Date: Sun, 22 Dec 2002 21:08:37 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: Ross Collado Sender: root@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: Ross Collado Subject: RE: Out of topic -Unx question Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 72; ListGuru (c) 1996-2001 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Not easily done in Unix. However, if you've got an Oracle db running on the same server you might want to get yesterday's date from Oracle (within a shell script). ... ... YESTERDAY=`sqlplus -s / <<-EOF set head off feed off pages 0 select trunc(sysdate - 1) from dual; exit EOF` echo "YESTERDAY is $YESTERDAY" ... ... hth, Ross -----Original Message----- Sent: Saturday, 21 December 2002 7:51 To: Multiple recipients of list ORACLE-L Hi All, I want to get previous date from today's date.Is there any cmd for this. Thanks Manoj -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: manoj.gurnani@orbitech.co.in 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: ListGuru@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.net -- Author: Ross Collado INET: Ross.Collado@techpac.com 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: ListGuru@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).