sql server - How to convert a byte[] into datetime in C#?

Question

I have a field of type TimeStamp in database, which is converted in byte[] in c# code, and i need to convert it to DateTime value. So i want to convert from an array of bytes into DateTime.

Already used this code:

byte[] byteValue = someValue;
long longVar = BitConverter.ToInt64(byteValue);
DateTime dateTimeVar = DateTime.FromBinary(longVar);

is this ok?

Answer 1

A timestamp column in SQL Server (now called rowversion) isn't convertable to a datetime value - it's purely a monotonically increasing value assigned by the server.