sunjincheng created FLINK-6893: ---------------------------------- Summary: Add BIN supported in SQL Key: FLINK-6893 URL: https://issues.apache.org/jira/browse/FLINK-6893 Project: Flink Issue Type: Sub-task Components: Table API & SQL Affects Versions: 1.4.0 Reporter: sunjincheng
BIN(N) Returns a string representation of the binary value of N, where N is a longlong (BIGINT) number. This is equivalent to CONV(N,10,2). Returns NULL if N is NULL. * Syntax: BIN(num) * Arguments **num: a long/bigint value * Return Types String * Example: BIN(12) -> '1100' * See more: ** [MySQL| https://dev.mysql.com/doc/refman/5.7/en/string-functions.html#function_bin] -- This message was sent by Atlassian JIRA (v6.4.14#64029)