I think we should do away with the need for timestamp columns in SQL. What’s the point? Data is data is data, we don’t need the time of every records entry! Andre Rencontre BCompSci, MCSE HLB Mann Judd Victoria, Australia
The timestamp column is used internally in SQL Server to handle changed records; it doesn’t have anything to do with date or time. If an application reads a record, and a little later wants to write to the same record, SQL Server must make sure that the record hasn’t been changed in the meantime – this is accomplished by the use of the timestamp column/data type. The timestamp column stores a binary number (much like Autonumber in MS Access)… the value does not have anything to do with the time or date. Best regards, Søren Pedersen