decrypt_time()
Description
Given an encrypted string created using encrypt_time() and a keyname, returns its decrypted cleartext.
function decrypt_time (inputString varbyte(16400), inputKeyname varchar(256)) returns varchar(8192) CHARACTER SET UNICODE
Example
The following example decrypts a time number:
# BTEQ -- Enter your SQL request or BTEQ command:
#select decrypt_time('455F982498C2D473B920FF26124832C2'xb,'ctp-key');
#select decrypt_time('455F982498C2D473B920FF26124832C2'xb,'ctp-key');
*** Query completed. One row found. One column returned.
*** Total elapsed time was 1 second.
thales.decrypt_time('455F982498C2D473B920FF26124832C2'xb,'ctp-key');
------------------------------------------------------------------------------
11:37:58.0000
