UUID_ TO_ BIN
Warning
SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.
On this page
Converts a string UUID value to a binary UUID value.
Syntax
UUID_TO_BIN(string_uuid, swap_time)
Arguments
string_
: A string UUID value.
swap_
: A flag value that can be 0 or 1.
Return Type
VARBINARY(16)
Remarks
-
If the argument is an invalid UUID value, it returns SQL
NULL
. -
UUID_
can take one or two arguments.TO_ BIN -
If
swap_
istime 0
,UUID_
is a one-argument function that returns the binary format in the same order as the string value.TO_ BIN -
If
swap_
istime 1
,UUID_
is a two-argument function that returns the binary format in different order as the string value.TO_ BIN It swaps the time-low(first) and time-high(third) groups of hexadecimal characters.
-
Examples
Converts the UUID in binary format and returns the binary format in hexadecimal format.
SELECT HEX(UUID_TO_BIN('d93f9a83-e032-4e25-80a6-d67235e68399'))AS result;
+----------------------------------+
| result |
+----------------------------------+
| D93F9A83E0324E2580A6D67235E68399 |
+----------------------------------+
Converts the UUID to binary format and returns it in hexadecimal format after swapping the time part.
SELECT HEX(UUID_TO_BIN('d93f9a83-e032-4e25-80a6-d67235e68399', 1))AS result;
+-----------------------------------+
| result |
+-----------------------------------+
| 4E25E032D93F9A8380A6D67235E683999 |
+-----------------------------------+
Last modified: December 2, 2024