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
) |
| 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
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
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
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
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
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
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
john.dunn@seTo: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
fas.co.uk cc:
Sent by: Subject: get yesterdays date
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
, 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
12 matches
Mail list logo