Re: get yesterdays date

2001-07-23 Thread MHately
I'll save you the trouble John; it was Sunday June 22nd. Sossy, couldn't resist. Alternatively you can select SYSDATE -1 from DUAL. Cheers, Mike Hately |+---> || John Dunn| || | || | |

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://www.

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:

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 PROT

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

RE: get yesterdays date

2001-07-23 Thread Jon Walthour
John: To get yesterday's, simply subtract 1 from sysdate ... like this: select sysdate-1 as yesterday from dual; Jon Walthour >--- Original Message --- >From: John Dunn <[EMAIL PROTECTED]> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Date: 7/23/01 7:35:53 AM > >Anyone know

Re: get yesterdays date

2001-07-23 Thread G . Plivna
select sysdate - 1 from dual; Gints Plivna John Dunn

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
try SELECT (sysdate - 1) FROM DUAL; MARK -Original Message- Karadeniz Sent: Monday, July 23, 2001 7:27 AM To: Multiple recipients of list ORACLE-L SELECT SYSDATE - 1 from DUAL; - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Monday, J