MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » November 2008

Re: Date arithmetic in SQL



fixed

Why yes there is.

And there was quite a discussion on this in the RPG list last week.

See these references
(date)
http://publib.boulder.ibm.com/infocenter/iseries/v5r3/topic/db2/rbafzmst02.htm#ToC_380
(days)
http://publib.boulder.ibm.com/infocenter/iseries/v5r3/topic/db2/rbafzmst02.htm#ToC_396
I am sure that if you figure it out from those links you will retain it a
lot more than if we give you a simple...

and search for "idate" at
http://www.think400.dk/downloads.htm
for when you are ready for the thorough answer.

Rob Berendt





Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact