how to get monthly date in teradata


I have a table called oth_mbr. I need to get 3 years of data month wise. current date minus 36 months and each month data betwwe from_dt and thru_dt needs to be fetched.

data shoulbe be in below formate

DATE , COLUMN A, COLUMN B 2017-08-01,FEP000,FPr 2017-09-01,FEP000,FPr 2017-10-01,FEP000,FPr . . . 2020-08-01,FEP000,FPr

tried below query but this gives only one data

SEL distinct ADD_MONTHS(DATE – DATE MOD 100 + 1,- 36) AS DATE , COLUMN 1,COLUMN 2 OTH_MBR WHERE ADDD_MONTHS(DATE – DATE MOD 100 + 1,- 36) BETWEEN FROM_DT AND THRU_DT

Result for above query is 2017-08-01,FEP000,FPr