# UUID\_TO\_BIN

Converts a string UUID value to a binary UUID value.

## Syntax

```sql
UUID_TO_BIN(string_uuid, swap_time)
```

## Arguments

`string_uuid`: A string UUID value.

`swap_time`: 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_TO_BIN` can take one or two arguments.

  * If `swap_time` is `0`, `UUID_TO_BIN` is a one-argument function that returns the binary format in the same order as the string value.
  * If `swap_time` is `1`, `UUID_TO_BIN` is a two-argument function that returns the binary format in different order as the string value. 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.

```sql
SELECT HEX(UUID_TO_BIN('d93f9a83-e032-4e25-80a6-d67235e68399'))
AS result;


```

```output

+----------------------------------+
| result                           |
+----------------------------------+
| D93F9A83E0324E2580A6D67235E68399 |
+----------------------------------+
```

Converts the UUID to binary format and returns it in hexadecimal format after swapping the time part.

```sql
SELECT HEX(UUID_TO_BIN('d93f9a83-e032-4e25-80a6-d67235e68399', 1))
AS result;


```

```output

+-----------------------------------+
| result                            |
+-----------------------------------+
| 4E25E032D93F9A8380A6D67235E683999 |
+-----------------------------------+
```

***

Modified at: December 2, 2024

Source: [/cloud/reference/sql-reference/identifier-generation-functions/uuid-to-bin/](https://docs.singlestore.com/cloud/reference/sql-reference/identifier-generation-functions/uuid-to-bin/)

(An index of the documentation is available at /llms.txt)