# BIN\_TO\_UUID

Converts a binary UUID value to a string UUID value.

## 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;

```

```output

+--------------------------------------+
| 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;


```

```output

+--------------------------------------+
| @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;


```

```output

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

```

```sql
SELECT BIN_TO_UUID(@binary_uuid,1) AS result;

```

```output

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

```

```sql
SELECT BIN_TO_UUID(@binary_uuid_swap,0) AS result;


```

```output

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

```sql
SELECT BIN_TO_UUID(@binary_uuid_swap,1) AS result;


```

```output

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

```

***

Modified at: December 2, 2024

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

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