From what I understand UUID is a unique number generated from
the current date and the MAC address of the computer that generated
it.
Is there any way I can decode a UUID to reveal this
information? I'm thinking I could save a few precious milliseconds
if I didn't have to store and retrieve dates from separate fields
in my tables.
Thanks, that's slightly beyond my level of comprehension at
the moment.
It seems I have muddied my data somewhat, creating both MySql
UUIDs directly inside Cfquery calls, and indirectly as CF UUIDS
assigned to variables. The result is that my tables contain both
(8-4-4-16) and (8-4-4-4-12) formats. =( I don't imagine this a huge
problem but I'll be more consistent in future.
> contain both (8-4-4-16) and (8-4-4-4-12) formats.
Generally speaking, this is no problem, other than an
aesthetic one. The
dashes are not meaningful data, they're just a visual aid (I
don't really
understand why they're there, to be honest).