access_time 3m languageEnglish
more_vert

BigQuery - Convert Bytes to BASE64 or HEX String

visibility 118 comment 0
BigQuery provides built-in functions to convert bytes to BASE64 or HEX string. SELECT TO_BASE64(MD5('ABC')) AS BASE64, TO_HEX(MD5('ABC')) AS HEX; Results: JSON result: [{"BASE64": "kC+90rHfDE9wtKXSNSXpMg==","HEX": "902fbdd2b1df0c4f70b4a5d23525e932"}]
thumb_up 0
comment Comments
No comments yet.