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