Re: Date problem

[Bob Helm <Bob.Helm@MEDIWARE.COM>]

Why not just do it like on Star Trek? Just say, "Computer, today's date
minus 7 days."

:-)

Sorry folks; it's been a long week.

B
The Programmer formerly known as Bob
Mediware Information Systems Inc.
(913) 307-1045
Bob.Helm@Mediware.com


-----Original Message-----
From: Wayne C. Findley [mailto:wfindley@JPSCO.COM]
Sent: Thursday, May 02, 2002 9:01 AM
To: SQR-USERS@list.iex.net
Subject: Re: Date problem


Here's the solution

--> select to_char(sysdate-7, 'DD-MON-YYYY') from dual;

Good Luck!




                      Erik Siradas
                      <erik_siradas@HOT        To:
SQR-USERS@list.iex.net
                      MAIL.COM>                cc:
                      Sent by:                 Subject:  Date problem
                      "Discussion of
                      SQR, Brio
                      Software's
                      database
                      reporting
                      language"
                      <SQR-USERS@list.i
                      ex.net>


                      05/02/02 09:22 AM
                      Please respond to
                      sqr-users






Hello all,

I have a problem that I hope someone out there can help me with.  I need to
make a program that gets a date in the DD-MON-YYYY format of 7 days prior
from the current date.  ie.  Today's date id 02-MAY-2002, I need to get
25-APR-2002.  Anyone have any idea how this can be done.  Thank you in
advance.

ERIK SIRADAS
PROGRAMMER/ANALYST
STATE UNIVERSITY OF NEW YORK COLLEGE AT BROCKPORT


_________________________________________________________________
Join the world's largest e-mail service with MSN Hotmail.
http://www.hotmail.com