Converts a UUID1 variable to a timestamp

uuid_as_timestamp.sql

SET @uuid='31ae75f0-cbe0-11e8-a147-bc5ff4690f6a';

SELECT
  IF(SUBSTRING(@uuid, 15, 1) = '1',
     '1582-10-15'  + INTERVAL (
       CONV(CONCAT(SUBSTRING(@uuid, 16, 3), SUBSTRING(@uuid, 10, 4), SUBSTRING(@uuid, 1, 8)),
            16, 10)
       / 10000000) SECOND,
     NULL) AS uuid_as_timestamp;