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)
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
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
fas.co.uk> cc:
Sent by: Subject: get yesterdays date
root@fatc
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
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
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
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
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-- (
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
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
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
12 matches
Mail list logo