469,631 Members | 1,225 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,631 developers. It's quick & easy.

The TIMESTAMP data type

Hi
I'm interested in using the timestamp data type & I have some questions.

As far as I can understand the contant of a timestamp column is a binary
value.
Is there any connection between that value and a valid date (as the word
timestamp means) or is it a left over from the days when the timestamp
value really was a datetime type (so it says in Books Online) ?
or is it just a unique identification of a row (a tuple id) ?
I tried converting a timestamp value to datetime and I got a date in 1900.

Thanks for any answer
David Greenberg

Jul 20 '05 #1
1 16480
David Greenberg <da*****@iba.org.il> wrote in message news:<3F**************@iba.org.il>...
Hi
I'm interested in using the timestamp data type & I have some questions.

As far as I can understand the contant of a timestamp column is a binary
value.
Is there any connection between that value and a valid date (as the word
timestamp means) or is it a left over from the days when the timestamp
value really was a datetime type (so it says in Books Online) ?
or is it just a unique identification of a row (a tuple id) ?
I tried converting a timestamp value to datetime and I got a date in 1900.

Thanks for any answer
David Greenberg


TIMESTAMP is a rather confusing name - in SQL2000 the synonym
ROWVERSION is preferred, which is a lot clearer. It's a unique value
which is changed every time the row is updated, so it can be used to
check if another user modified a row since you last queried it. If the
timestamp column has a different value than the one you saw, then the
row has been updated.

There's no connection with datetime data, but in the ANSI SQL
standard, TIMESTAMP is the equivalent of SQL Server's DATETIME, which
leads to some confusion.

Simon
Jul 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by kingofkolt | last post: by
7 posts views Thread by laurenq uantrell | last post: by
1 post views Thread by Roger Twomey | last post: by
4 posts views Thread by Mark Harrison | last post: by
5 posts views Thread by pankaj_wolfhunter | last post: by
5 posts views Thread by kyosohma | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.