Will unique_rowid() loop in year 2038?

Wondering if this will overflow once we reach the end of unix time epoch.

Hi @gnat ! The unique_rowid function has a 48-bit timestamp stored at a granularity of 10 microseconds, meaning it can work for 89 years. Also, the beginning epoch is changed to be Jan 1, 2015. That means the timestamp will overflow on Jan 1, 2104.

1 Like

Great answer @rafiss Thank you for the quick reply.