Re: Date arithmitic in SQL

["Jim Essinger" <dilbernator@xxxxxxxxx>]

Jeff,

I use Allan's iDate UDF to do that kind of thing.  He has programmed
both translate from number to date and date to number.

His utility can be downloaded from
http://www.think400.dk/downloads.htm  which includes good clear
install instructions.

Good luck

Jim

On Tue, Nov 18, 2008 at 1:54 PM, Jeff Young <cooljeff913@xxxxxxxxx> wrote:
> Is there a way to add or subtract a duration (# of days) to a Date field in SQL.
> What I have is a field containing a numeric representation of a date in a file.
> I want to use SQL to increment that field by a specific value.
>
> I am using a V5R3 system.
>
>
> Thanks,
>
> Jeff Young
> Sr. Programmer Analyst
> IBM -e(logo) server Certified Systems Exper - iSeries Technical Solutions V5R2
> IBM  Certified Specialist- e(logo) server i5Series Technical Solutions Designer V5R3
> IBM  Certified Specialist- e(logo)server i5Series Technical Solutions Implementer V5R3
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.