Interprete a UUID

Back

UUID: 
Your input:                      e3a7e415-2a05-870a-87e9-5ce32bd83b97

Various notations:

URN:                             urn:uuid:e3a7e415-2a05-870a-87e9-5ce32bd83b97
URI:                             uuid:e3a7e415-2a05-870a-87e9-5ce32bd83b97
Microsoft GUID syntax:           {E3A7E415-2A05-870A-87E9-5CE32BD83B97}
C++ struct syntax:               { 0xe3a7e415, 0x2a05, 0x870a, { 0x87, 0xe9, 0x5c, 0xe3, 0x2b, 0xd8, 0x3b, 0x97 } }

As OID (ISO/ITU-T 128 bits):     2.25.302606494684737317498867200175304620951
As OID (Microsoft):              1.2.840.113556.1.8000.2554.58279.58389.10757.34570.34793.6087467.14171031
As OID (Waterjuice 2x64 bits):   1.3.6.1.4.1.54392.1.16404330947270772490.9793460995456777111
As OID (Waterjuice 4x32 bits):   1.3.6.1.4.1.54392.2.3819430933.705005322.2280217827.735591319
As OID (Waterjuice 8x16 bits):   1.3.6.1.4.1.54392.3.58279.58389.10757.34570.34793.23779.11224.15255

Interpretation of the UUID:

Variant:                         [0b10_] RFC 9562 (Davis-Peabody-Leach)
Version:                         [0x8] Custom implementation
Custom data:                     [0xe3a7e4152a0570a07e95ce32bd83b97]
Custom data block1 (32 bit):     [0xe3a7e415]
Custom data block2 (16 bit):     [0x2a05]
Custom data block3 (12 bit):     [0x70a]
Custom data block4 (14 bit):     [0x07e9]
Custom data block5 (48 bit):     [0x5ce32bd83b97]

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

Random 16 bits:                  [0xe3a7] 0b1110001110100111
Milliseconds:                    [0xe4] 893 (deviation -2ms..2ms)
Seconds:                         [0x15] 21
Minute of day:                   [0x052a] 1322 (22:01)
Day of year:                     [0x0a7] 167 (Day=16, Month=6)
Unused 2 bits:                   [0] 0b00
Year:                            [0x7e9] 2025
Signature:                       [0x5ce32bd83b97] HickelSOFT "SQL Server Sortable Custom UUID", Version 3 (very likely)
UTC Date Time:                   2025-06-16 22:01:21'893 (deviation -2ms..2ms)