You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@flink.apache.org by "jackylau (Jira)" <ji...@apache.org> on 2022/08/09 12:06:00 UTC
[jira] [Created] (FLINK-28893) Add conv function supported in SQL & Table API
jackylau created FLINK-28893:
--------------------------------
Summary: Add conv function supported in SQL & Table API
Key: FLINK-28893
URL: https://issues.apache.org/jira/browse/FLINK-28893
Project: Flink
Issue Type: Improvement
Components: Table SQL / API
Affects Versions: 1.16.0
Reporter: jackylau
Fix For: 1.16.0
Returns true if {{array}} contains {{{}value{}}}.
Syntax:
{code:java}
conv(number, fromBase, toBase) {code}
Arguments:
* number: INTEGER_NUMERIC or CHARACTER_STRING family.
* fromBase: INTEGER_NUMERIC family.
* toBase: INTEGER_NUMERIC family.
Returns:
Converts numbers between different number bases. Returns a string representation of the number {_}{{N}}{_}, converted from base _{{from_base}}_ to base {_}{{to_base}}{_}. Returns {{NULL}} if any argument is {{{}NULL{}}}. The argument _{{N}}_ is interpreted as an integer, but may be specified as an integer or a string. The minimum base is {{2}} and the maximum base is {{{}36{}}}. If _{{from_base}}_ is a negative number, _{{N}}_ is regarded as a signed number. Otherwise, _{{N}}_ is treated as unsigned. [{{CONV()}}|https://dev.mysql.com/doc/refman/8.0/en/mathematical-functions.html#function_conv] works with 64-bit precision.
Examples:
{code:java}
> SELECT CONV(100, 10, -8);
"144"
> SELECT CONV(1111, 2, 10);
15
> SELECT CONV(100, 2, NULL);
NULL {code}
See more:
* pg: [https://dev.mysql.com/doc/refman/8.0/en/mathematical-functions.html#function_conv]
* mariadb: https://mariadb.com/kb/en/conv/
--
This message was sent by Atlassian Jira
(v8.20.10#820010)