Help Center/ Data Lake Insight/ Spark SQL Syntax Reference/ Built-In Functions/ Mathematical Functions/ conv
Updated on 2023-10-25 GMT+08:00
View PDF

conv

This function is used to convert a number from from_base to to_base.

Syntax

conv(BIGINT num, INT from_base, INT to_base)

Parameters

Table 1 Parameters

Parameter

Mandatory

Type

Description

num

Yes

DOUBLE, BIGINT, DECIMAL, or STRING

Number whose base needs to be converted

The value can be a float, integer, or string.

from_base

Yes

DOUBLE, BIGINT, DECIMAL, or STRING

It represents the base from which the number is converted.

The value can be a float, integer, or string.

to_base

Yes

DOUBLE, BIGINT, DECIMAL, or STRING

It represents the base to which the number is converted.

The value can be a float, integer, or string.

Return Values

The return value is of the STRING type.

  • If the value of num, from_base, or to_base is NULL, NULL is returned.
  • The conversion process works with 64-bit precision and returns NULL when there is overflow.
  • If the value of num is a decimal, it will be converted to an integer before the base conversion, and the decimal part will be discarded.

Example Code

The value 8 is returned.

select conv('1000', 2, 10);

The value B is returned.

select conv('1011', 2, 16);

The value 703710 is returned.

select conv('ABCDE', 16, 10);

The value 27 is returned.

select conv(1000.123456, 3.123456, 10.123456);

The value 18446744073709551589 is returned.

select conv(-1000.123456, 3.123456, 10.123456);

The value NULL is returned.

select conv('1100', null, 10);
Parent topic: Mathematical Functions