I have a Json Data source configured to get data from external application. I am seeing the data . But there are 2 cols, Updated At and Created At. values in those columns are coming in the format
I tried creating a new field, used substr to parse out the 8 numbers to get to 15899328 and use cast function to convert to date. Not working. getting null values.
Can anybody help how to convert this to a date format in Denodo Integration view?