uuid_version()
Extract the version of a UUID
Since 2.23.0
Extract the version number from a UUID object:
Samples
Section titled “Samples”SELECT uuid_version('019913ce-f124-7835-96c7-a2df691caa98');Returns something like:
uuid_version-------------- 7Arguments
Section titled “Arguments”The syntax is:
SELECT uuid_version( uuid = <uuid>);| Name | Type | Default | Required | Description |
|---|---|---|---|---|
uuid | UUID | - | ✔ | The UUID object to extract the version number from |
Returns
Section titled “Returns”| Column | Type | Description |
|---|---|---|
uuid_version | INTEGER | The version number extracted from the UUID object (e.g., 7 for UUIDv7). |