to_base()

Converts a value to a string in the given base radix, optionally padding with leading zeros to the minimum length

Arguments & returns

2 overloads

Scalar

Overload link	`number`	`radix`	Returns
#01	`BIGINT`	`INTEGER`	`VARCHAR`

Scalar

Overload link	`number`	`radix`	`min_length`	Returns
#02	`BIGINT`	`INTEGER`	`INTEGER`	`VARCHAR`

SELECT to_base(42, 16, 5);

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

SELECT
  to_base(42, 16);