BigQuery - Convert Bytes to BASE64 or HEX String
insights Stats
warning Please login first to view stats information.
Raymond
Code Snippets & Tips
Code snippets and tips for various programming languages/frameworks. All code examples are under MIT or Apache 2.0 license unless specified otherwise.
BigQuery provides built-in functions to convert bytes to BASE64 or HEX string.
Code snippet
SELECT TO_BASE64(MD5('ABC')) AS BASE64, TO_HEX(MD5('ABC')) AS HEX;
Results:
JSON result:
[{"BASE64": "kC+90rHfDE9wtKXSNSXpMg==","HEX": "902fbdd2b1df0c4f70b4a5d23525e932"}]
copyright
This page is subject to Site terms.
comment Comments
No comments yet.