Conversion Functions

Conversion functions convert data values of various datatypes to the datatype specified by the function name.

• ascii()
  Scalar. Returns the Unicode code point for a particular character, or the UTF-8 code point if the -U server option is specified.
• base64_binary()
  Scalar. Returns a binary value for a given base64-encoded string.
• base64_string()
  Scalar. Returns a base64-encoded string for a given binary value.
• cast()
  Scalar. Converts the value of one datatype to another datatype allowing overflows and truncation.
• char()
  Scalar. Returns the characters responding to one or more Unicode code points, or the UTF-8 code points if the -U server option is specified.
• dateint()
  Converts a date to an integer that represents the number of seconds since 1970-01-01 00:00:00 UTC (the Epoch).
• extract()
  Scalar. Extracts and returns a portion of a given binary value.
• fromnetbinary()
  Scalar. Converts a binary in network byte order to an integer in host byte order.
• hex_binary()
  Scalar. Converts a hex string into a binary type.
• hex_string()
  Scalar. Converts a binary value into a hex string.
• intdate()
  Scalar. Converts an integer representing the number of seconds since 1970-01-01 00:00:00 UTC (the Epoch) to a date.
• msecToTime()
  Scalar. Converts a given number of milliseconds to a bigdatetime.
• recordDataToRecord
  Converts the binary errorRecord value to a RECORD datatype value, based on the schema of the specified source stream.
• recordDataToString
  Converts the binary errorRecord value to string format.
• secToTime()
  Scalar. Converts a given number of seconds to a bigdatetime.
• string()
  Scalar. Converts a given value of any type to an equivalent string.
• timeToMsec()
  Scalar. Converts a bigdatetime to the number of milliseconds since the epoch (midnight, January 1, 1970).
• timeToUsec()
  Scalar. Converts a bigdatetime to the number of microseconds since the epoch (midnight, January 1, 1970).
• timeToSec()
  Scalar. Converts a bigdatetime to the number of seconds since the epoch (midnight, January 1, 1970).
• to_bigdatetime()
  Scalar. Converts a given value to a bigdatetime.
• to_binary()
  Scalar. Converts a given value to a binary value.
• to_boolean()
  Scalar. Converts a given value to a Boolean value.
• to_date()
  Scalar. Converts a given value to a date.
• to_decimal()
  Scalar. Converts a boolean, integer, or money value to a decimal value with total digits and digits to the right of the decimal as specified.
• to_float()
  Scalar. Converts a given value to a float.
• to_integer()
  Scalar. Converts a given value to an integer.
• to_interval()
  Scalar. Converts a given value to an interval.
• to_long()
  Scalar. Converts a given value to a long.
• to_money()
  Scalar. Converts a given value to the appropriate money type, based on a given scale.
• to_string()
  Scalar. Converts a given value to a string.
• to_timestamp()
  Scalar. Converts a given value to a timestamp.
• to_xml()
  Scalar. Converts a given value to XML.
• totimezone()
  Converts a date from the given time zone to a specified time zone.
• tonetbinary()
  Scalar. Converts an integer in host byte order to a 4 byte binary in network byte order.
• usecToTime()
  Scalar. Converts a given number of microseconds to a bigdatetime.