i have no date field in my data
ex year month
i want to convert this one as date like 01/05/2017,01/06/2017
Please help me to sort out this issue
What's the datatype of those columns?
INT: Cast((year-1900)*10000 + (month*100 + 1 AS DATE)
CHAR: Cast(year||month AS DATE Format 'yyyymm')