encrypt_date()
Description
Given a cleartext string in DATE dataype format and a keyname, returns its encrypted equivalent.
function encrypt_date (inputdata date, inputKeyname varchar(256)) returns varbyte(16000)
Example
The following example encrypts a date number:
#select encrypt_date(DATE '2019-03-20','ctp-key');
#select encrypt_date(DATE '2019-03-20','ctp-key');
System Response
*** Query completed. One row found. One column returned.
*** Total elapsed time was 2 seconds.
thales.encrypt_date(DATE '2019-03-20','ctp-key');
-----------------------------------------------------
F8BD65A76B9B5D5ED135CDE7F8E2DB13
