|
HI, I PUT A TIMESTAMP ON MY TABLE AND WHEN I SEE THE TABLE THE TIMESTAMP SHOWS ME "0X0000007D3" WHAT DOES IT MEAN. HOW TO READ A REAL TIME ON A TIMESTAMP DATATYPE. THANKS |
|
the timestamp is not really a date & time stamp ! it is a row version. The timestamp data type has been deprecated in SQL Server 2008 use rowversion instead refer to http://msdn.microsoft.com/en-us/library/aa260631%28SQL.80%29.aspx THANKS,I CHANGED TO ROWVERSION AND IT STLL SHOWING 0X0000007D4.THERE IS NOW WAY TO SEE THE DATE TIME EVERY TIME I UPDATE A COLUNM
(Mar 29 at 13:44)
WENCESLAS
SORRY "NO WAY"I MEANT
(Mar 29 at 13:45)
WENCESLAS
TIMESTAMP or ROWVERSION will not give you the DATE TIME at all. Add a datetime column to your table and update it via your application or trigger
(Mar 29 at 22:21)
Squirrel
|
|
Ditto Squirrel above...can't use it to get time. It can be used to compare with other rows for the sequence it was entered. |
