date minus one

From: "Knight, Jon" <jknight@xxxxxxxxxxxxxx>
To: oracle-l <oracle-l@xxxxxxxxxxxxx>
Date: Tue, 29 Mar 2005 12:55:06 -0600

  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

Follow-Ups:

Re: date minus one
From: stephen booth

Re: date minus one
From: Wolfgang Breitling

Re: date minus one
From: Jared Still

Other related posts:

Browse oracle-l