For one of our client, we have a date stored in one of the columns in the Oracle database in Unix format and I’m trying to convert this into standard date format using the transformation ' timestamp_epoch'. Unfortunately while running the import program, I’m getting an error message “The format "YYYY-MM-DD HH:mm:ss" is invalid for an epoch time stamp transformation.”. I tried different format like ‘MM/dd/yyyy HH:mm:ss’ , ‘yyyy-MM-dd HH:mm:ss.SSS Z’, 'd.M.yyyy H:mm:ss' but nothing is working.
Can you please help me with which format I need to use so that I don’t get this error message and it gets transformed to the date format successfully?
Example values for the input: 1613437797, 1601895975.