encrypt_time()
Description
Given a cleartext string in TIME datatype format and a keyname, returns its encrypted equivalent.
function encrypt_time (inputdata time, inputKeyname varchar(256)) returns varbyte(16000)
The input string must adhere to BTEQ requirements, such as escaping special characters. For example, if the input string contains an apostrophe, use a double apostrophe: 'It''s a beautiful day'.
Example
The following example encrypts a time number:
#select encrypt_time(TIME '11:37:58','ctp-key');
#select encrypt_time(TIME '11:37:58','ctp-key');
System Response
*** Query completed. One row found. One column returned.
*** Total elapsed time was 2 seconds.
thales.encrypt_time(TIME '11:37:58','ctp-key')br /----------------------------------------------
-------br /455F982498C2D473B920FF26124832C2
