Reading timestamp value form Sybase DB

[Guest]

I'm trying to read the timestamp value from the DB into a template column
within a datagrid. The issue I'm having is that the value displayed is
"System.Byte []".

Do I have to do any operations to get it in this format ->
"0x000100000139d595" which is the format it's in the DB.

Thanks,

 

[Mary Chipman]

The timestamp data type in SQL Server is a unique (within the
database) binary value whose sole purpose in life is to version-stamp
a row of data in a table. When a client sends an update to the table,
the timestamp of the row originally retrieved by the client is
compared (by the server) to the value that is currently in the row to
see if there has been a concurrency violation. It has nothing to do
with the date or time, and is just an 8-byte value. Why do you need to
display it in a datagrid?

--Mary

 

[Nathan Waddington]

I'm running into the same problem. I'd like to display it because i'd
like to see when the last time the record was changed. Should i use a
DateTime with a few triggers and stored procedures instead? Is it not
possible to show the Timestamp in a datagrid?

The timestamp data type in SQL Server is a unique (within the
database) binary value whose sole purpose in life is to version-stamp
a row of data in a table. When a client sends an update to the table,
the timestamp of the row originally retrieved by the client is
compared (by the server) to the value that is currently in the row to
see if there has been a concurrency violation. It has nothing to do
with the date or time, and is just an 8-byte value. Why do you need to
display it in a datagrid?

--Mary

I'm trying to read the timestamp value from the DB into a template column
within a datagrid. The issue I'm having is that the value displayed is
"System.Byte []".

Do I have to do any operations to get it in this format ->
"0x000100000139d595" which is the format it's in the DB.

Thanks,