Timestamp datatype in SQL 7

[JackV]

I have a timestamp in one of my tables and I was wondering is there anyway to translate the value (ex. 0x00000000000000DC) that SQL 7 stores in the field into a legible date and or time.

Thanks,
Jack Vinitsky

[JHausmann]

A table of yours or a system table?

[Clunietp]

The Timestamp data type is a binary field and is NOT an actual Date/Time stamp. It is a unique value within your database and is updated whenever the record is inserted or updated.

This field is often used to determine if a record has been updated by one client while another client is about to edit/update that same record. If the value in the timestamp field does not match that which is in the ADO recordset, then your record needs to be refreshed.

There was a nice article in VBPJ a few months back, and they explained how to use the timestamp data type so you can have multi-user apps WITHOUT locking any records

[JackV]

The field is in one of my tables. But since it's a binary field I guess I can't do much with it directly.

Thanks for the info guys I appreciate it.

-Jack