Available in versions: Dev (3.20)

This documentation is for the unreleased development version of jOOQ. Click on the above version links to get this documentation for a supported version of jOOQ.


Applies to ✅ Open Source Edition   ✅ Express Edition   ✅ Professional Edition   ✅ Enterprise Edition

The BIN_TO_UUID() function converts a BINARY(16) representation into a VARCHAR or UUID representation. See also UUID_TO_BIN for the inverse function.

SELECT bin_to_uuid(binaryData);

The result being

| bin_to_uuid                          |
| 1fc454e5-b9f6-4d55-b783-5987fe76cb45 |
binToUuid(new byte[16])

References to this page


Do you have any feedback about this page? We'd love to hear it!

The jOOQ Logo