Try date + 1 year
Unconfigured Ad Widget
Collapse
Announcement
Collapse
No announcement yet.
Date arithmetic for Interactive SQL on the AS/400
Collapse
X
-
Date arithmetic for Interactive SQL on the AS/400
Can anyone tell me how to do arithmetic with date fields using STRSQL. For example, I want to update a date field in a file for certain records. How would I add 1 year to the DATE01 field? Would it be something like: UPDATE MYLIB/FILEA SET DATE01 = DATE01 + (what goes here????) Thank You
-
Date arithmetic for Interactive SQL on the AS/400
Check http://www.mcpressonline.com/mc?prin...ae.1@.6ae58825 posting. It has some examples
Comment
Comment