Data Type timestamp

Hi,

I am a bit confused...

is the data type in sql express similar to DateTime? in other words can i convert this timestamp to DateTime or can i use this data type instead of the data type DateTime?

regards,

rnv

Even they store both 8 bytes, they are not the same, read more for this in the BOL.

timestamp

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.

Remarks

The Transact-SQL timestamp data type is not the same as the timestamp data type defined in the SQL-92 standard. The SQL-92 timestamp data type is equivalent to the Transact-SQL datetime data type.

http://msdn.microsoft.com/library/en-us/tsqlref/ts_ta-tz_6fn4.asp

If you want to use something like rowversioning, use ROWVERSION not datetime, as datetime has only the limitation to a precision of 3ms.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||

thanks a lot.

|||Could you please mark the post as solved then, thanks.

Jens.