• The timestamp data type doesnt preserve time or date data. It is for versioning a row and is automatically populated when an insert or update takes place.

    Take a look at this MSDN page for more info: http://msdn.microsoft.com/en-us/library/ms182776.aspx

    Thanks,

    Matt.