BIN_TO_UUID

Syntax

SQL

BIN_TO_UUID(binary_uuid, swap_time)

Arguments

binary_uuid: A binary UUID value.

swap_time: A flag value that can be 0 or 1.

Return Type

VARCHAR(36)

Remarks

If the argument is an invalid UUID value, it returns SQL NULL.
BIN_TO_UUID can take one or two arguments.
- If swap_time is 0, BIN_TO_UUID is a one-argument function that returns the string format in the same order as the binary value.
- If swap_time is 1, BIN_TO_UUID is a two-argument function that returns the string format in a different order than the binary value. It assumes that the time-part swapping is already done and swaps the time-low (first) and time-high (third) groups back to their original positions.

Examples

Returns the UUID in string format.

SQL

SELECT BIN_TO_UUID(SYS_GUID()) AS string_uuid_value;

+--------------------------------------+
| string_uuid_value                    |
+--------------------------------------+
| c591b267-59a8-4d8c-89de-f16c5951bf31 |
+--------------------------------------+

SYS_GUID() returns a new GUID in every call, the output may differ if called multiple times.

Returns the UUID in string format before and after swapping the time-part.

SQL

SELECT UUID() INTO @uuid;
SELECT @uuid;

+--------------------------------------+
| @uuid                                |
+--------------------------------------+
| 08f2a3da-4561-4880-a528-0ac0bf15c52d |
+--------------------------------------+

SQL

SELECT UUID_TO_BIN(@uuid,0) INTO @binary_uuid;
SELECT UUID_TO_BIN(@uuid,1) INTO @binary_uuid_swap;
SELECT BIN_TO_UUID(@binary_uuid,0) AS result;

+--------------------------------------+
| result                               |
+--------------------------------------+
| 08f2a3da-4561-4880-a528-0ac0bf15c52d |
+--------------------------------------+

SQL

SELECT BIN_TO_UUID(@binary_uuid,1) AS result;

+--------------------------------------+
| result                               |
+--------------------------------------+
| 45614880-a3da-08f2-a528-0ac0bf15c52d |
+--------------------------------------+

SQL

SELECT BIN_TO_UUID(@binary_uuid_swap,0) AS result;

+--------------------------------------+
| result                               |
+--------------------------------------+
| 48804561-08f2-a3da-a528-0ac0bf15c52d |
+--------------------------------------+

SQL

SELECT BIN_TO_UUID(@binary_uuid_swap,1) AS result;

+--------------------------------------+
| result                               |
+--------------------------------------+
| 08f2a3da-4561-4880-a528-0ac0bf15c52d |
+--------------------------------------+