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|
|| |
|| |
|
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.
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:
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
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
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
select sysdate - 1 from dual;
Gints Plivna
John Dunn
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
>
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
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
10 matches
Mail list logo