decrypt_timestamp()
Description
Given an encrypted string created using encrypt_timestamp() and a keyname, returns its decrypted cleartext.
function decrypt_timestamp (inputString varbyte(16000), inputKeyname varchar(256)) returns timestamp
Example
The following example decrypts a timestamp number:
# BTEQ -- Enter your SQL request or BTEQ command:
#select decrypt_timestamp
('E4B5E6FD2C86E2B8F41A92F554ECAA02B5007986DB21BF1A1D95D24F80064107'xb,'ctp-key');
#select decrypt_timestamp
('E4B5E6FD2C86E2B8F41A92F554ECAA02B5007986DB21BF1A1D95D24F80064107'xb,'ctp-key');
*** Query completed. One row found. One column returned.
*** Total elapsed time was 1 second.
thales.decrypt_timestamp
('E4B5E6FD2C86E2B8F41A92F554ECAA02B5007986DB21BF1A1D95D24F80064107'xb,'ctp-key')
------------------------------------------------------------------------------------------------
-------------
2021-03-20 19:22:05.000000
