RE: Need inputs related to SQL statements involving date

I think, u can run this statement.

       select date(days(current date)- x )  from file

         x- number of days
         file - u can use any PF  or LF


Thanks and Regards

Subba Reddy
Senior Software Engineer
--------------------------------------------
Patni Computer Systems Ltd
Bldg No. 306, Sector 2,
Millennium Business Park,
Mahape,
Navi Mumbai 400 701
India

Tel : +91 22 27781011-14 Ext. No. 4302
Fax: +91 22 2778 1007
http://www.patni.com
-----------------------------------------------
This e-mail message may contain proprietary, confidential or legally
privileged information for the sole use of the person or entity to whom
this message was originally addressed. Any review, e-transmission
dissemination or other use of or taking of any action in reliance upon
this information by persons or entities other than the intended
recipient is prohibited. If you have received this e-mail in error
kindly delete this e-mail from your records. If it appears that this
mail has been forwarded to you without proper authority, please notify
us immediately at netadmin@xxxxxxxxx and delete this mail.



-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx]On Behalf Of
muthathal.ramasamy@xxxxxxx
Sent: Martes, 21 de Febrero de 2006 12:36 p.m.
To: RPG programming on the AS400 / iSeries
Subject: Need inputs related to SQL statements involving date



Hello all,

Could someone of you provide me a sample SQL statement involving
appropriate date-time functions
that would subtract some "x" number of days from the current date and
yield a new date?

The above requirement has to be acheived using SQL statement only in the
case we have.

Thanks in advance for all the inputs.

Thanks.
Muthu

Notice: The information contained in this e-mail message and/or attachments
to it may contain confidential or privileged information.   If you are not
the intended recipient, any dissemination, use, review, distribution,
printing or copying of the information contained in this e-mail message
and/or attachments to it are strictly prohibited.   If you have received
this communication in error, please notify us by reply e-mail or telephone
and immediately and permanently delete the message and any attachments.
Thank you
--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.