ali
July 2, 2001, 02:28 pm
Hi,
I am trying to find a way to read the timestamp of a particular record within an SQL table. I understand that the @@DBTS global variable will return the most recent timestamp for an entire database, but I am concerned with retrieving the timestamp of a specified record/row within a table. Basically I am trying to figure out how to retrieve the timestamp value from its binary format so that I can save it in another table and use it for future timestamp comparisons. When I try a normal SELECT query I get a type mismatch error.
Any ideas?
Thanks,
Alisa
------------------
al
I am trying to find a way to read the timestamp of a particular record within an SQL table. I understand that the @@DBTS global variable will return the most recent timestamp for an entire database, but I am concerned with retrieving the timestamp of a specified record/row within a table. Basically I am trying to figure out how to retrieve the timestamp value from its binary format so that I can save it in another table and use it for future timestamp comparisons. When I try a normal SELECT query I get a type mismatch error.
Any ideas?
Thanks,
Alisa
------------------
al