date minus one

From: Knight, Jon <jknight_at_concordefs.com>
Date: Tue, 29 Mar 2005 12:55:06 -0600
Message-ID: <17ECCBDCF27C544583F2CAD928F953260221FB97@memex1.corp.cefs.int>

Just curious how the rest of the world gets "yesterday" in UNIX. We're running Solaris and we execute a sqlplus script with "select sysdate-1 from dual;" and pipe it to tail to set an environment variable.

Is there a more UNIXy way, -or- maybe a java function. Any suggestions welcome.

TIA,
Jon Knight

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Mar 29 2005 - 13:59:01 CST

This message: [ Message body ]
Next message: Tanel P?der: "Re: parse cpu and recursive cpu"
Previous message: Jared Still: "Re: parse cpu and recursive cpu"
Next in thread: stephen booth: "Re: date minus one"
Reply: stephen booth: "Re: date minus one"
Maybe reply: Reidy, Ron: "RE: date minus one"
Reply: Wolfgang Breitling: "Re: date minus one"
Maybe reply: Thomas Jeff: "RE: date minus one"
Maybe reply: Anthony Molinaro: "RE: date minus one"
Maybe reply: Knight, Jon: "RE: date minus one"
Maybe reply: Reidy, Ron: "RE: date minus one"
Reply: Jared Still: "Re: date minus one"
Maybe reply: Graeme St. Clair: "RE: date minus one"
Maybe reply: Ian Cary (C): "RE: date minus one"
Maybe reply: Knight, Jon: "RE: date minus one"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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