RE: get yesterdays date

2001-07-23 Thread Mark Liggayu
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 > -- > Author: John Dunn > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858)

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 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

Re: get yesterdays date

2001-07-23 Thread G . Plivna
fas.co.uk> cc: Sent by: Subject: get yesterdays date root@fatc

RE: get yesterdays date

2001-07-23 Thread Jon Walthour
7/23/01 7:35:53 AM > >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: (8

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 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

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 yeste

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-- (

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 t

Re: get yesterdays date

2001-07-23 Thread MHately
bject: 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 Dunn

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