Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: date minus one

RE: date minus one

From: Knight, Jon <jknight_at_concordefs.com>
Date: Wed, 30 Mar 2005 10:39:35 -0600
Message-ID: <17ECCBDCF27C544583F2CAD928F953260221FB9D@memex1.corp.cefs.int>


So many solutions ... so little time. Thanks everyone!

Thanks,
Jon Knight

 -----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Connor McDonald

Sent:	Wednesday, March 30, 2005 7:28 AM
To:	oracle-l_at_freelists.org
Subject:	RE: date minus one

I don't have a unix box handy, but I dug up this from my archives

TZ=aaa24 date +%Y%m%d

hth
connor

Connor McDonald
Co-author: "Mastering Oracle PL/SQL - Practical Solutions" Co-author: "Oracle Insight - Tales of the OakTable"

web: http://www.oracledba.co.uk
web: http://www.oaktable.net
email: connor_mcdonald_at_yahoo.com

"GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day"




Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Mar 30 2005 - 11:43:30 CST

Original text of this message

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