Question: How to create a SQL Server GUID (v8) with a specific timestamp?

[ShayMusachanov-dev]

Hi,

First off, this library is incredibly helpful. We nearly made a big mistake by trying to use the built-in Guid.CreateVersion7() with SQL Server. Your library exactly addressed the key byte-sorting differences in uniqueidentifier. Thanks to it, we avoided a major headache, and we truly appreciate the effort you've put into this!

I have a question regarding creating UUIDs for SQL Server. I'm trying to generate a SQL Server-compatible GUID (v8) using a specific, known timestamp for our use case.

I've been looking through the documentation, and I can see:

public static Guid CreateUuidV7FromSpecificDate(DateTimeOffset date)

I can't find an equivalent method for creating a SQL Server-compatible v8 GUID from a specific DateTimeOffset.

Am I missing something, or is there another way to achieve this with the existing methods? If not, would this be a feature request? A method like CreateUuidV8FromSpecificDate(DateTimeOffset) would be beneficial.

[mareek]

Hi @ShayMusachanov-dev,

Thank you for the kind words. There is currently no way to create a SQL Server GUID with a specific timestamp.
I've labeled this issue as a feature request and I will try to add this capability to UUIDNext in the coming weeks

[mareek]

Hi @ShayMusachanov-dev, with the 4.2.0 version, you can now create a SQL Server GUID with a specific timestamp withe the new UuidToolkit.CreateSequentialUuidForSqlServerFromSpecificDate function. (see #33 for more details)