What is the SQL Server timestamp equivalent in sqlce?

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 t开发者_JAVA百科he SQL Server timestamp equivalent in sqlce?

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

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.

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