I understand your point, but '2000-01-01' :: timestamp and '1900-01-01' :: timestamp are both valid timestamps.
So looks strange if user can do select uuidv7(TIMESTAMP '2000-01-01') but cannot do select uuidv7(TIMESTAMP '1900-01-01') Regards Marcos Em qua., 24 de jan. de 2024 às 14:51, Andrey Borodin <x4...@yandex-team.ru> escreveu: > > > > On 24 Jan 2024, at 22:00, Marcos Pegoraro <mar...@f10.com.br> wrote: > > > > Is enough from 1970 ? > Per standard unix_ts_ms field is a number of milliseconds from UNIX start > date 1970-01-01. > > > How about if user wants to have an UUID of his birth date ? > > I've claimed my > 0078c135-bd00-70b1-865a-63c3741922a5 > > But again, UUIDs are not designed to store timestamp. They are unique and > v7 promote data locality via time-ordering. > > > Best regards, Andrey Borodin.