Re: get yesterdays date

select sysdate-1 from dual;

>>> john.dunn_at_sefas.co.uk 07/23/01 07:35AM >>>
Anyone know how to get yesterdays date in PL/SQL?

John

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: John Dunn
  INET: john.dunn_at_sefas.co.uk 

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_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).

------------------------------------------------------------
This electronic mail (e-mail) and any files transmitted with
it are confidential and are intended solely for the use of
the individual or entity to whom they are addressed.
Personal views and opinions expressed in this communication
are those of the originator and may not necessarily reflect
those of O'Brien & Gere and O'Brien & Gere shall not be
liable for any damage caused by or resulting from any such
material. If you are NOT the original recipient or the person
responsible for delivering the e-mail to the intended
recipient, be advised that you have received this e-mail
in error, and that any use, dissemination, forwarding,
printing, or copying of this e-mail is strictly prohibited.
If you received this e-mail in error or any objectionable
material, please delete it and immediately notify
"Postmaster_at_Obg.Com"

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: William Beilstein
  INET: BeilstWH_at_obg.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_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).