I have the following data in one of the columns of my table and each data is supposed to be encrypted
1415131228
1415131215
1415914797
1415131174
1415131173
The thing is that I don't know what type of encryption it is, nor how to decrypt it, the column is type VARCHAR2 and what I am supposed to find when decrypting it is a date with time included, but I don't know with what procedure, query or function to obtain the data I require.
I am working SQL - PL/SQL - External Tables - Oracle 11g
Dates, noting that they are numerical values very close to each other, do not appear to be encrypted, but encoded in UNIX/POSIX timestamp format .
To convert them back to datetime format you can use the following SQL query:
You can see the example working online at the following link: