Type Conversion Functions

Function Description
BINARY_STRING([string] giventext) Converts giventext to binary.
CAST([any type] value AS < type>) Converts value to a type specified by < type>.
CONVERT_FROM(expression, [literal string] conv_type) Converts the byte data in expression to the type specified in conv_type. expression can be a literal string or a field name.
CONVERT_FROM(expression, 'UTF8', [character] replacement char) Converts the byte data in expression to UTF-8. Expression can be a literal string or a field name. Will replace any invalid UTF-8 characters with the replacement character.
CONVERT_TO(expression, [literal string] conv_type) Converts expression to bytes, depending on the type specified in conv_type. expression can be a literal value (string, number, etc.) or a field name.
IS_UTF8(expression) Returns true if expressions is valid UTF-8, otherwise returns false.
STRING_BINARY([binary] data) Returns the bytes in data as a string. Unprintable bytes are given in hexadecimal with a preceding '\x'.
TO_CHAR(expression, [literal string] format) Converts expression to a string using the format specified in format. expression can be a literal value (string, number, etc.) or a field name.
TO_DATE([number] epochms) Converts epochms, the Unix time given in milliseconds, to a date.
TO_DATE([string] giventext, [literal string] format) Converts giventext to a date using the format given in format.
TO_NUMBER([string] giventext, [literal string] format) Parses the string giventext into a number according to the format indicated in format.
TO_TIME([number] ms) Converts ms, the number of milliseconds since midnight, to a time.
TO_TIME([string] giventext, [literal string] format) Converts giventext to a time using the format given in format.
TO_TIMESTAMP([number] epochsec) Converts the Unix time epochsec to a timestamp (date & time).
TO_TIMESTAMP([string] giventext, [literal string] format) Converts giventext to a timestamp (date & time) using the format given in format.
TYPEOF([field name] givenfield) Returns the type(s) of values in givenfield.

results matching ""

    No results matching ""