Interprete a UUID

Back

UUID:
Your input:                      407bda22-01ec-8016-87e9-5ce32bd83b96

Various notations:

URN:                             urn:uuid:407bda22-01ec-8016-87e9-5ce32bd83b96
URI:                             uuid:407bda22-01ec-8016-87e9-5ce32bd83b96
Microsoft GUID syntax:           {407BDA22-01EC-8016-87E9-5CE32BD83B96}
C++ struct syntax:               { 0x407bda22, 0x01ec, 0x8016, { 0x87, 0xe9, 0x5c, 0xe3, 0x2b, 0xd8, 0x3b, 0x96 } }

As OID (ISO/ITU-T 128 bits):     2.25.85713668503480917595074837073320491926
As OID (Microsoft):              1.2.840.113556.1.8000.2554.16507.55842.492.32790.34793.6087467.14171030
As OID (Waterjuice 2x64 bits):   1.3.6.1.4.1.54392.1.4646547280158818326.9793460995456777110
As OID (Waterjuice 4x32 bits):   1.3.6.1.4.1.54392.2.1081858594.32276502.2280217827.735591318
As OID (Waterjuice 8x16 bits):   1.3.6.1.4.1.54392.3.16507.55842.492.32790.34793.23779.11224.15254

Interpretation of the UUID:

Variant:                         [0b10_] RFC 9562 (Davis-Peabody-Leach)
Version:                         [0x8] Custom implementation
Custom data:                     [0x407bda2201ec01607e95ce32bd83b96]
Custom data block1 (32 bit):     [0x407bda22]
Custom data block2 (16 bit):     [0x01ec]
Custom data block3 (12 bit):     [0x016]
Custom data block4 (14 bit):     [0x07e9]
Custom data block5 (48 bit):     [0x5ce32bd83b96]

Interpretation of HickelSOFT "SQL Server Sortable Custom UUID", Version 2

Random 16 bits:                  [0x407b] 0b0100000001111011
Milliseconds:                    [0xda] 854 (deviation -2ms..2ms)
Seconds:                         [0x22] 34
Minute of day:                   [0x01ec] 492 (08:11)
Day of year:                     [0x016] 22 (Day=22, Month=1)
Unused 2 bits:                   [0] 0b00
Year:                            [0x7e9] 2025
Signature:                       [0x5ce32bd83b96] HickelSOFT "SQL Server Sortable Custom UUID", Version 2 (very likely)
UTC Date Time:                   2025-01-22 08:11:34'854 (deviation -2ms..2ms)