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.

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 thread ...


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