What is the SQL Server timestamp equivalent in sqlce?

Question

I have some data with a timestamp in SQL Server, I would like to store that value in sqlce with out getting fancy to compare the two values.

What is the SQL Server timestamp equivalent in sqlce?

Answer 1

Timestamp is from MS Docs

timestamp is a data type that exposes automatically generated binary numbers, which are guaranteed to be unique within a database. timestamp is used typically as a mechanism for version-stamping table rows. The storage size is 8 bytes.

This value makes no sense outside the database it was created in. Thus I don't see how it can be converted.

In a non Sybase/ SQL Server database I would use a version number or last updated column

Answer 2

AS of Sql Compact 3.5, there is support for timestamps, per MSDN:

SQL Server Compact implements the timestamp (rowversion) data type. The rowversion is a data type that exposes automatically generated binary numbers, which are guaranteed to be unique in a database. It is used typically as a mechanism for version-stamping table rows.

Answer 3

Ok the timestamp is a varbinary that auto generates. So to copy a time stamp you need a varbinary field.