As400 SQL: Date to Interger conversion

Date to Int conversion:

 Select 

int(substr(char( year(current date)*10000 + month(current  

date)*100 + day(current date)),3))

from Sysibm/Sysdummy1

2017/05/11 = 170511

To get the integer value of date 8 months from today:

 Select 

int(substr(char( year(current date - 8 Months)*10000 + month(current  date - 8 months)*100 + day(current date - 8 Months)),3))

from Sysibm/Sysdummy1

2016/11/08 = 161,108