RE: date minus one

From: Thomas Jeff <jeff.thomas_at_thomson.net>
Date: Tue, 29 Mar 2005 14:33:35 -0500
Message-ID: <428BC948616D534DA0860EDF33F542AB3FBF98@INDYSMAIL02.am.thmulti.com>

That's exactly what I do, e.g:

export YESTERDAY=3D`TZ=3DGMT+24 date +"%Y%m%d"` =20

$ TZ=3DGMT+24 date +"%Y%m%d"

20050328                        =20

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Wolfgang Breitling Sent: Tuesday, March 29, 2005 2:29 PM
To: jknight_at_concordefs.com
Cc: oracle-l
Subject: Re: date minus one

One trick is to temporarily advance the TZ to a time zone further west,=20 get your date, and then reset TZ again:

$ echo $TZ
MST7MDT
$ date +"%Y-%m-%d"
2005-03-29
$ TZ=3DMST22MDT
$ date +"%Y-%m-%d"
2005-03-28
$ TZ=3DMST7MDT
$

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

>=20

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

>=20

> TIA,
> Jon Knight

>=20

> --
> http://www.freelists.org/webpage/oracle-l
>=20

--=20
Regards

Wolfgang Breitling
Centrex Consulting Corporation
www.centrexcc.com

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

Received on Tue Mar 29 2005 - 14:37:32 CST