get yesterdays date

2001-07-23 Thread John Dunn
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: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access

Re: get yesterdays date

2001-07-23 Thread MHately
) | | Subject: get yesterdays date | | Anyone know how to get yesterdays date in PL/SQL? John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John

Re: get yesterdays date

2001-07-23 Thread Dennis M. Heisler
select trunc(sysdate) - 1 from dual; John Dunn wrote: 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: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http

Re: get yesterdays date

2001-07-23 Thread William Beilstein
select sysdate-1 from dual; [EMAIL PROTECTED] 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: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858

AW: get yesterdays date

2001-07-23 Thread PRIBILLA . Michael
Title: AW: get yesterdays date Hi John, try select trunc(sysdate) - 1 from dual Regards, Michael -Ursprüngliche Nachricht- Von: John Dunn [mailto:[EMAIL PROTECTED]] Gesendet am: Montag, 23. Juli 2001 13:36 An: Multiple recipients of list ORACLE-L Betreff: get yesterdays date

RE: get yesterdays date

2001-07-23 Thread Shahid Malik(IT)
select sysdate-1 from dual; -Original Message- Sent: Monday, July 23, 2001 4:36 PM To: Multiple recipients of list ORACLE-L 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: [EMAIL

RE: get yesterdays date

2001-07-23 Thread Cale, Rick T (Richard)
I am not sure of exact syntax but just select sysdate -1 into variable from dual; Rick -Original Message- Sent: Monday, July 23, 2001 7:36 AM To: Multiple recipients of list ORACLE-L Anyone know how to get yesterdays date in PL/SQL? John -- Please see the official ORACLE-L FAQ

RE: get yesterdays date

2001-07-23 Thread Jon Walthour
to get yesterdays date in PL/SQL? John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: get yesterdays date

2001-07-23 Thread G . Plivna
john.dunn@seTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] fas.co.uk cc: Sent by: Subject: get yesterdays date

Re: get yesterdays date

2001-07-23 Thread Bunyamin K. Karadeniz
SELECT SYSDATE - 1 from DUAL; - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, July 23, 2001 2:35 PM Anyone know how to get yesterdays date in PL/SQL? John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com

RE: get yesterdays date

2001-07-23 Thread Deewaker G.V.
Title: RE: get yesterdays date select sysdate - 1 from dual; -Original Message- From: John Dunn [mailto:[EMAIL PROTECTED]] Sent: Monday, July 23, 2001 5:06 PM To: Multiple recipients of list ORACLE-L Subject: get yesterdays date Anyone know how to get yesterdays date in PL/SQL

RE: get yesterdays date

2001-07-23 Thread Mark Liggayu
, July 23, 2001 2:35 PM 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: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California