TIL that timestamp of Microsoft SQL Server is not a date or time data type but only a deprecated synonym for rowversion.
The Transact-SQL rowversion data type is not a date or time data type. timestamp is a deprecated synonym for rowversion.
Source: Date and Time Data Types and Functions - SQL Server (Transact-SQL) | Microsoft Docs
But rowversion doesn't preserve date or time either.
Is a data type that exposes automatically generated, unique binary numbers within a database. rowversion is generally used as a mechanism for version-stamping table rows. The storage size is 8 bytes. The rowversion data type is just an incrementing number and does not preserve a date or a time.
Source: rowversion (Transact-SQL) - SQL Server | Microsoft Docs