Encryption Function



The MD5 function returns the MD5 128-bit checksum for the input character string. The result value is displayed as a character string that is expressed in 32 hexadecimals, which you can use to create hash keys, for example.

Parameters:string -- Input string. If a value that is not a VARCHAR type is entered, it will be converted to VARCHAR.
Return type:STRING

The return value is a VARCHAR (32) type and if an input parameter is NULL, NULL will be returned.

SELECT MD5('cubrid');


SELECT MD5(255);


SELECT MD5('01/01/2010');


SELECT MD5(CAST('2010-01-01' as DATE));

   md5( cast('2010-01-01' as date))

Table Of Contents

Previous topic

Information Functions

Next topic

Comparison Expression

This Page